Format Currency & Percent in Make Table Query

[inhops]

I have added the correct format (via Properties) to my query. When I run it as a select query the currency & percent formats appear correctly. But when I run it as a Make Table query, the table does not have the correct formats. I can format the table that is made, but then the next time I run the Make Table query, the formatting is gone. How can I get the correct formatting into the table that is made with the Make Table query? Thanks for your help.

[June7]

Would need a VBA procedure to modify those properties.

Why do you need to repeatedly run the same MAKE TABLE query? This sounds like a design flaw in the db.

[inhops]

The query is very complicated because it is based on multiple other queries. And we have duplicate data in some of the input files, so I have to do intermediate queries to remove the duplicates (First of). So I was hoping to have the result be a table that the client can look at often and export and not have to run the query each time.

Can you suggest some code for a VBA procedure to format the table correctly?

Another option I thought of is to use an append query and delete all of the records in the table before the append each time. But I can't figure out how to delete all of the records in the table.

Thanks for your help.

[orange]

For DELETE query see
http://www.techonthenet.com/sql/delete.php

BUT be careful, once you delete the data is gone, no undo.

I would not recommend a repeated Make Table approach and feel it may be a design flaw also.
When you add data to your table, you could add the current date. Then only use records with the current date in subsequent processes -- NO DELETEs.

Also, you could use a YesNo type flag on your table. Suppose a field called LogicallyDeleted where Yes means the field is "Deleted". So when you do your processing you only Select those records where LogicallyDeleted is Not Yes.

Just some more fuel for the fire.