MS Access Round() Function
Example
Round the Price column (to 1 decimal) in the "Products" table:
SELECT ProductName, Price, Round(Price, 1) AS RoundedPrice
FROM Products;
Try it Yourself »
Definition and Usage
The Round() function returns a number rounded to a certain number of decimal places.
Note: If the expression that you are rounding ends with a 5, the Round() function will round the expression 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 Round() function will return an integer |
Technical Details
| Works in: | Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000 |
|---|
More Examples
Example
Select the records that have a price above the average price:
SELECT * FROM Products
WHERE Price > (SELECT Avg(Price) FROM Products);
Try it Yourself »
