Change "Text" to "Number"

L

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
 
J

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
 
Top