Make Table Query Data Type in Table

[gracm25]

When I run my make table query (to enter a 1 or 2 digit number into a table), the data type of that field in the table becomes "binary". How can I get that to change to double, or long integer, or some numerical format?

 

[HiTechCoach]

If you will be doing this repeatedly, I prefer to crate the table manually and the use a delete query to empty the table and then use an Append query to add the data. This will give you a lot more control over the table's design.


If you want to use a make tbale query, then you could try using the Cint() function to convert the data type within the query.

Cint([FieldName]) as intFieldName

or if Double datatype then

CDbl([FieldName]) as intFieldName