$ and decimals in calculation

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.

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

"troublecat12" wrote in message
...
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.