$ and decimals in calculation

[Guest]

I have a calculation in a query based on currency in my table. However, the
results show up without a $ symbol or the two decimal places I have in my
table results. How do I get the calculated results to display in the same
format?

Thanks.

 

[Jeff Boyce]

One approach might be to set the Format property of that field in your
query.

Open the query in design view, highlight the entire "column" containing the
field/calculation, right-click, and set the Format to Currency. Does that
do what you need?

Or, if you are using your query to "feed" a form or report, you could set
the display/format there...

Regards

Jeff Boyce
Microsoft Office/Access MVP