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

Retaining format using a make table query

P: 10
Hi again everyone.

Learning such a lot from this forum, it is a great resource for a newbie like me!!! And I thank everyone for their contributions.

My problem,

I have a "make table query" and one of the columns is in a currency format. When I hit the run button it makes the new table but the corresponding column in the new table has a “number” format. How do I retain the formating. I have gone into the table and changed the format to currency, but i loose every thing after the decimal point, and when i run it again i am back to square one.

Any ideas !!!

Thanks Guys and Girls
Aug 11 '08 #1
Share this Question
Share on Google+
4 Replies

Expert Mod 10K+
P: 14,534
Please post the SQL of the Make Table Query.
Aug 12 '08 #2

Expert Mod 15k+
P: 31,489
Are you sure a Make Table is what you're after.

A Make Table query will delete (completely) any similarly named table before recreating it from your SQL.

It sounds like what you really need is an append query to add your data into an EXISTING table (that you've already formatted correctly). Remember to clear the existing data from the table first if that's what you need.
Aug 12 '08 #3

P: 10
My Thanks to you msquared & NeoPa,

I have no idea what I have done, but it now seems seems to be working!!!!!!!!!!!!!!!!! The joy of access!!!!!!!!!!!!

It is a macro that involved taking data from three tables and putting it into two new ones. Then I am appending data from one of the new tables to the other table, printing a report from that table and finally deleting the both the new tables.

Well, it all is working now and a sigh of relief.

Thanks for the offer of help, I am sure that I will be asking again. This is a Great site for dimwits like me and I really appreciate your hard work.

Aug 12 '08 #4

Expert Mod 15k+
P: 31,489
No worries Scottie, and thanks for posting back.

Welcome to Bytes!
Aug 12 '08 #5

Post your reply

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