Retaining format using a make table query

[scottie]

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

[MMcCarthy]

Please post the SQL of the Make Table Query.

[NeoPa]

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.

[scottie]

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.

Scottie

[NeoPa]

No worries Scottie, and thanks for posting back.

Welcome to Bytes!