make new table

  • Thread starter Thread starter Garry
  • Start date Start date
G

Garry

Hi all

When making a new table from a query is it possible
to change a fields property from say number too text.

cheers
 
You might do that by wrapping the number in Str(), e.g.:
Str([MyNumberField])

But the best solution is to set up the table the way you want it, and then
populate it with an Append query instead of using a Make Table.

(If this is something you do repeatedly, use a Delete query to empty it
instead of deleting the table and re-creating it.)
 
Back
Top