Example
SELECT ProductName, Price, Round(Price, 1) AS RoundedPrice
FROM Products;Definition and Usage
The Round() function rounds a number to a specified number of decimal places.
Note
If the expression ends with a 5, this function rounds so that the last digit is an even number. Here are some examples:
Round(34.55, 1) - Result: 34.6 (rounds up) Round(34.65, 1) - Result: 34.6 (rounds down)
Syntax
Round(
expression
,
decimal_places
)Parameter Values
| Parameter | Description |
|---|---|
| expression | Required. A numeric expression to be rounded |
| decimal_places | Optional. The number of decimal places to round the expression to. If omitted, the function rounds to the nearest whole number |
Technical Details
| Works in: | From Access 2000 |
|---|