Data Type in make Table query 1

[AccessVB]

I have wasted more hours than necessary on this one...I have a field that has numbers in it coming in from various tables. when i run a make table query, this field is output into the created table as a text filed, how do I fix this? Can anyone help?

 

[JoanneM]

Hello


Use the Cint function or Cdbl dependant upon type of number

there is also Ccurr which has been used to maintain decimal places by some programmers( though I've never found out why when there is format)

hope this helps

jo

 

[willybgw]

Try this.
1. After running the make table query go into design view of the new table and change the data types and field sizes to what you want them to be.

2. Create a delete query to clear the new table.

3. Change the make table query to an append query.

4. Create a macro to open delete query then open append query. Set warnings off before the querys and back on after them.

 

[AccessVB]

Thanks you two...bith the methods worked, Cint method was easier for what i needed...thanks again