Keeping formats in MakeTable Query

[Btinker]

When I create a make table query and apply a format
(currency, 2 decimal places) to a field the format does
not come over to the resulting table. Is there a way I
can make this happen? Thanks.

 

[John Vinson]

When I create a make table query and apply a format
(currency, 2 decimal places) to a field the format does
not come over to the resulting table. Is there a way I
can make this happen? Thanks.

Only (to my knowledge) by opening the tabledef for the new table in
VBA and tweaking the Format property of the field.

One major question: why do you need a maketable query AT ALL? they are
very rarely really necessary; ordinarily you can simply create a
select query (which *will* know about all your formats) and base a
Form, Report, Export, or another query on it directly. What do you
gain from creating a new table?

 

[John Vinson]

The data is extracted from the mainframe large data set
and it runs faster is our subset is pulled down via a
make table query. Other ideas are welcome.

You might try having a table set up with the desired formats. Rather
than running a MakeTable query you could run a Delete query to empty
out the previous data, followed by an Append query to populate it.
This will not only preserve the formats, but will usually run faster
and cause less bloat than a MakeTable.

Be sure to Compact regularly in any case - neither deleting and
recreating a table, nor emptying and refilling it, will recover the
lost disk space!