Last updated: August 25, 2026.
The Microsoft Access Round function rounds a numeric expression to a specified number of decimal places.
Syntax
Round(expression [, numdecimalplaces])| Argument | Description |
|---|---|
expression | Required numeric value or expression. |
numdecimalplaces | Optional number of decimal places. The default is zero. |
Examples
Round(12.345, 2) ' 12.34
Round(12.355, 2) ' 12.36
Round([UnitPrice], 2) ' Value from an Access fieldAccess uses banker’s rounding: an exact halfway value is rounded toward the nearest even digit. This can differ from the rule commonly taught as “always round 5 up.” Test financial calculations with representative values, and use a purpose-built expression when a different rounding policy is required.
Moving an Access application to the web? See how PHPRunner can replace Microsoft Access forms and reports.
