Changing the format of a field while doing a make table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a transaction table that has fields such as CustomerID, CustomerName
and Amount. The Amount field is a general number format which I cannot
change. I create a make table every day which creates the sales by month for
all customers. When I create this make table I want to change the format of
this field from General Number to Currency so that when the new table is made
every day, the Amount field is currency.

Can anyone help?

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get Access to append the exact amount with decimals? 2
automate the Changing of the format of field from number to curren 2
Decimal Field's Precision Too Small to accept the numeric you ... 3
Changing the format of a field 1
FORMATTING RESULTS IN CALCULATED FIELD 4
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Appending new records to a table 2
Two tables, multiple relationships? 1

Back
Top