Repeating Decimal

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

In some of my reports I have an average function and the
ones that repeat such as 1.33333333333 go out about ten
places. How can I shorten this to say 1.33? Thanks.

Brian
 
In the report's design view, select the properties for the
text field in question, then set Format = Fixed and
Decimal Places = 2. That should do it!
 
Check Access Help on the Format Property of the Textbox Control.

You can also use the Format() function.
 
Open the report in design view.
Right-click the text box, and choose Properties.
On the Format tab of the Properties box, set:
Format Fixed
Decimal Places 2

Note that this does not round the results. You are modifying the display
only.
 
Back
Top