In Access, the Rnd function returns a single containing a random number. You can specify the random number to be a value between 2 user-specified numbers.

The syntax for the Rnd function is:

Rnd ( number )

The argument number can be any valid numeric expression. The Rnd function returns a value less than 1 but greater than or equal to zero. To produce random integers in a given range, use this formula:

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

Here, upperbound is the highest number in the range, and lowerbound is the lowest number in the range.

Example

Int((7-1 +1) * Rnd + 1)              returns a random value between 1 and 6. Int((30-20 +1) * Rnd + 20)           returns a random value between 20 and 30.

VBA Code

Dim MyNumber MyNumber = Int((6-1+1)*Rnd +1)

This example uses the Rnd function to generate a random integer from 1 to 6. Now the MyNumber variable would contain this value.

SQL query

You can also use the Rnd function in a query.

SELECT Int((10-1+1)*Rnd()+1) AS Expr1 FROM Orders