make table query

[Joshy]

After I set the properties (format and decimal properties) for fields of a make-table query, I previewed the resultant (using 'view' command)table and everything turned out just the way I expected (I had adjusted so that it would round all numbers to 1 decimal place).
However, the resultant table did not turn out the same. The format and decimal properties was set back to its default. Is there a way of solving this problem without adjusting the properties of the table?
I've been baffled by this for a while, any help would be greatly appreciated.
josh

 

[llkhoutx]

A make table query deletes the old table before the (new) table is created. Worry about formating at display or use time, not when the data is stored. When displayed or used it can be formatted if and as necessary.