Bugl — code interview practice that feels like a game

Loading lesson path

Flash cards

Review the key moves

1/4

Core idea

What is the main idea behind MS Access Round() Function?

Lesson checks

Short Mimo-style checks built from this lesson's code, terms, and sequence.

1Quick choice

Which statement best captures the main point of this lesson?

2Fill blank

Complete the missing token from the example code.

___ ProductName, Price, Round(Price, 1) AS RoundedPrice

3Order

Put the learning moves in the order that makes the concept easiest to apply.

The Round() function rounds a number to a specified number of decimal places.

Definition and Usage

MS Access Round() Function

Example

 SELECT ProductName, Price, Round(Price, 1) AS RoundedPrice
FROM Products;

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	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

Works in:	From Access 2000