Adjust Decimals on a Calculated Report Field

  • Thread starter Thread starter Boomer
  • Start date Start date
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.
 
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")
 
Back
Top