Changing data type in make table queries

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

I am using a make table query. What I want to know is can
I change the data type of one of the field I am creating
in the new table? For example can I change a field with a
data type numeric in the existing table to a field with
the data type text in the newly created table. Can this be
done in the SQL code?

Thanks In Advance


Martin
 
Try type-casting the field. e.g.:
SELECT Str([MyNumberField]) As MyTextField ...
 
Back
Top