Change "Text" to "Number"

[learning_codes]

Hi,

I don't have a problem creating query to make a table. I have one
"field A" that has TEXT on query. I create "Make Table" from Query Tab.
I couldn't make the "FIELD A" from TEXT to NUMBER after making a table
from Query Tab.

I would need your help and how to insert Query Field to use NUMBER
instead of TEXT.

Your help would be much appreciated.

Thanks

 

[Jeff Boyce]

You haven't described why you are making a table. It sounds like you with
end up with two copies of the same data, in two tables. This is rarely
necessary in Access.

If you want a query to produce a numeric value (say, an Integer) from a text
field, you can use the CInt() (or other "Convert-to" functions) to coerce a
text-type number to be a number..

Regards

Jeff Boyce
Microsoft Office/Access MVP