Make Table Query - Formatting Percentages

[Guest]

Hi there,

I'm creating a new table using the Make Table query in Access. The table
has about 8 columns that should display percentages with 3 decimal places.
I've set the formatting of these columns, and when you view the results of
the query the formatting is correct.

However, when you actually run the Make Table query and view the table it
created, the formatting of these columns is lost.

How do you format these columns so that they appear in the new table?

Thanks!

 

[Guest]

In design view of the table, blue triangle in the upper left corner, you can
change the data type to currency down below in the properties change it to a
% format and show 3 decimals

 

[Guest]

Hi ... we actually already tried this and it does work. Except every time we
re-run the make table query it overwrites that formatting.

Is there no way to include the formatting for the table in the query so we
don't have to manually change it?

Thanks!

 

[John Spencer]

How about not doing a make table every time?

Just run a delete query to clean out the table and then do an Append query
instead of the Maketable query.

If you do that you can have all your indexes and formats set up and not need
to modify the table after you "make" it.