make new table

[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

 

[Allen Browne]

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.)

 

[Guest]

Try this ---
Expr1: Str([yourNumberField])
Then rename Expr1 after you make the table.