Using a Make table query to change data type

G

Guest

I have make table query and I need to change some text fields to number
fields and some text fields to date fields. Just an fyi the fields are
perorming a calculation based on data from and as400 system. Example Actual
Days: numberOfDays([BKATTR],[ACTIONDATE]) this field needs to be a number.

Can someone help?

Thanks,

Moses
 
J

John Vinson

I have make table query and I need to change some text fields to number
fields and some text fields to date fields. Just an fyi the fields are
perorming a calculation based on data from and as400 system. Example Actual
Days: numberOfDays([BKATTR],[ACTIONDATE]) this field needs to be a number.

Can someone help?
Click to expand...

I'd suggest a different approach. MakeTable queries are a rather blunt
tool!

Create your target table with the desired datatypes, and run an Append
query instead. If you need to periodically import new data, simply
empty the table with a Delete query and re-append rather than dropping
the table and running a MakeTable. In either case... compact
regularly!

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make table query: [Enter 1] AS Test 1
data type for Make Table Query 1
Using query to make a table 3
Make Table Query 1
Convert datatype using query 7
Make Table Query Truncating Memo Field at 255 Characters 2
Make table query with calculated date fields 9
Make table query 1

Top