Rnd() and Round Function in MS Access

1. Rnd() Function :
Rnd() function return the random number.if we want to generate a number between 0 to 1 then use only Rnd. Otherwise, if we want to generate a number between a range then we will use the formula Int ((upperbound – lowerbound + 1) * Rnd + lowerbound).

Syntax :

• If we want to generate between 0 to 1 –

  Rnd 

• If we want to generate in a range –

  Int((upperbound - lowerbound + 1) * Rnd + lowerbound) 

Example-1 :

SELECT Int ((10 - 1 + 1) * Rnd + 1) AS RandNumBetween1and10;

Output –

RandNumBetween1and10
8

Example-2 :

SELECT Rnd AS RandNumBetween0and1;

Output –

RandNumBetween0and1
0.705547511577606

2. Round() Function :
Round() function returns rounds a number to a specified number of decimal places.In this function we will pass an expression and the second parameter will be decimal places till that the number will be rounded.

Note :
If the number ends with 5 then this function rounded last digits as even number.

Syntax :

Round(expression, decimal_places)

Example-1 :

SELECT Round(23.67, 1) As round;

Output –

round
23.7

Example-2 :

SELECT Round(45.65, 1) As round;

Output –

round
45.6

My Personal Notes arrow_drop_up

Save