make new table

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
 
A

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

KARL DEWEY

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