Changing the format of a field while doing a make table

[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,

 

[Allen Browne]

Try typecasting the Amount with CCur(), e.g.:
CCur(Nz([Amount],0))

More info on typecasting:
http://allenbrowne.com/ser-45.html