How To Take Advantage of Rounding

The results of value expressions are rounded automatically, but only after the entire expression has been evaluated. (During evaluation, full decimal values are used.)

The final result takes on the number of decimal places found in the operand with the most decimal places.

The rounded result is further rounded if it is being assigned to a named constant, a variable, a field, or a form field defined to contain fewer decimal places.

To force rounding in particular circumstances, use the $round function.

Examples of Rounding


Result is 3.


Result is 2.5.


Result is 2.01.


Result is 3.51.


Result is 4 if Integer is defined to contain no decimal places.