Repeating Decimal

[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

 

[mark]

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!

 

[Van T. Dinh]

Check Access Help on the Format Property of the Textbox Control.

You can also use the Format() function.

 

[Allen Browne]

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.

 

[Brian]

Simple enough. Thanks.