automate the Changing of the format of field from number to curren

[Guest]

Hi,

Every night I run a series of make tables that are based on some
transactional tables. The field in the transactional table is formatted as a
number field which I cannot change. I created a make table called
QuarterlySales that has the customer name and their sales which is a number
field. I would like to change this field to a currency field when I create
my make table every night or as a separate update type of query. I then want
to put this in a macro that runs in batch so that every night I have a
refreshed QuarterlySales table with this currency field.

Can someone help?

Thanks,

 

[[MVP] S.Clark]

Instead of a Make Table, can you Append to an existing one? This way, you
can leave the field intact between runs. Obviously delete the old data
before appending.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting

 

[Guest]

Steve,

Thanks for your help. I know how to append data to a table but am unsure
how to run an append that will simply change the format.

Thanks,