Decimal places in report


C

Caroline

I am having a hard time getting the correct number of decimal places to
display in a report. I have set "Materials Savings" to Currency with 2
decimal places in the table which it first exists, the query that uses that
table, in the report that uses the query which uses the table, etc. In my
footer of my report, I am trying to do running total of the Total Materials
Savings. The correct number shows up, but I can't get the $ sign or 2 decimal
places to show up.
In my text box, I have:
="Total Material Savings: " & "$" & Sum([Material Savings])
I've tried using Round and CCur, but neither changed it. Let me know what
I'm doing wrong. Thanks!
 
Ad

Advertisements

Ad

Advertisements

F

Fred

Hello Caroline

Try

="Total Material Savings: " & format(Sum([Material Savings]),"$#,###.00")
(untested)
 

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

Access stripping decimal places in query 1
Formatting decimal places 8
Decimal Places 1
Decimal places in charts 4
decimal places in a table 1
Conditional Decimal Places 7
Decimal Places 1
Access Inventory Calculation 0

Top