如何在ms-access中将文本转换为Number [英] how to convert text to Number in ms-access

问题描述

从mst_MiscItems中选择item_description，在这里item_type =摘要报告" ORDER BY item_value;

但是项目值包含Text，所以我想将其转换为Number，在ms-aceess中可以有任何一个请告诉我以上查询中的更正.

SELECT item_description FROM mst_MiscItems WHERE item_type=''Summary reports'' ORDER BY item_value;

But item value contain Text so i want to convert in Number, in ms-aceess can any one please tell me corrction in above query . how to convert it from text to number in ms-access.

推荐答案

使用它.

Use this.

SELECT CInt(item_description) FROM mst_MiscItems WHERE item_type='Summary reports' ORDER BY item_value;

hi.

尝试下面的链接.

[1]
> [2]



希望对您有帮助.
祝你好运. :)



-chaosgray-

hi.

try the links below.

[1]
[2]



hope it helps.
goodluck. :)



-chaosgray-

这篇关于如何在ms-access中将文本转换为Number的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！