By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,917 Members | 1,305 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,917 IT Pros & Developers. It's quick & easy.

Make Table Query & Losing Format

P: 9

I have a query that I would like to run periodically to drop the data in an existing table and re-write the table with the query information.

However, when I do this, some of my field formatting for calculated query fields are dropped.

For example. In the query, the FIELD1= $4,500 but when the make table query is run, the FIELD1 = 4500.25

In the query, I am using (0) decimals.

Anyone know how to fix this?
Oct 3 '07 #1
Share this Question
Share on Google+
3 Replies

Expert 2.5K+
P: 3,072
An easy workaround is to use an append query instead.
Just create the table first by making a copy of the structure only or by copying a specially created empty "template" table with the correct formatting and use the append query to preserve the formatting of the table.

Idea ?

Oct 6 '07 #2

P: 9
Thanks. I think I might use this.

I created a query that will delete the table that I will run before each append. Otherwise, each time I appended data, it would just keep adding the same rows.

I'm sure I could get away from that by adding a primary key to the data, however, this will allow any changes in numbers to be re-appended.

So, my first query will run a delete and my second query will run an append.

Anything else I could do to simplify this?

Thanks for the idea!
Oct 8 '07 #3

Expert 2.5K+
P: 3,072
The number of rows you append will determine the time the "delete *" query will take.
When you have a lot of records, it's faster to "DROP" the table and use a COPY of a template table.

Both ways will however work as it allows you to set the formatting of the fields as you need them :-)

Oct 8 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.