ROUND()

ROUND() returns a rounded whole number from a numeric expression or field value. Use ROUND() whenever you want to round an expression to the nearest whole number.

Function Format

ROUND(N)

ROUND() returns a number equal to the numeric expression or field value N rounded to the nearest integer. This function rounds 0.5 upwards (for example, away from zero).

This function is exactly the same as:

DECIMAL(N,0)

Examples

ROUND(7.2) = 7

ROUND(7.5) = 8

ROUND(-7.5) = -8

To create a field that is equal to the balance rounded to the nearest dollar value, specify:

ROUND(Balance)