Adjust Decimals on a Calculated Report Field

B

Boomer

I have a query that calculates the difference between two
dates. A report, based upon that query, calculates the
average of the difference. How can I get the average to
show only one decimal place. It currently shows all. I
have made the Decimal Property equal to 1 with no result.
 
F

fredg

I have a query that calculates the difference between two
dates. A report, based upon that query, calculates the
average of the difference. How can I get the average to
show only one decimal place. It currently shows all. I
have made the Decimal Property equal to 1 with no result.
Click to expand...

Use a calculated control:
=Format([YourField],"#0.0")
 

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 a calculated Text Box 9
How can I set decimal places in a calculated control on a rpt? 2
Currency format with 2 decimals not showing on report 2
Access stripping decimal places in query 1
Decimals and SubReports 1
calculations in report controls 4
Getting decimal places to display in a report in text boxes 1
Added zero's on a percentage field 4

Top