$ and decimals in calculation

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

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.
 
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
 

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

Decimal places in calculated fields 6
Number of decimal places output 8
Access stripping decimal places in query 1
Restrict percents so they will not show decimal (i.e. 61% not 61.2 1
How do I get Access to append the exact amount with decimals? 2
Decimal format 3
Decimal Place problem 2
Posting Calculated Data to a Table 3

Back
Top