MS Access Rnd Function
Example
Generate one random number between 1 and 10, and another random number between 100 and 499:
SELECT Int((10 - 1 + 1) * Rnd + 1) AS RandNumBetween1and10,
Int((499 - 100
+ 1) * Rnd + 100) AS RandNumBetween100and499;
Try it Yourself »
Definition and Usage
The Rnd function generates a random number.
Note: If you do not call the Randomize() function before calling the Rnd function, the Rnd function may return the same random number each time!
Syntax
Int((upperbound - lowerbound + 1) * Rnd + lowerbound)Parameter Values
| Parameter | Description |
|---|---|
| upperbound | Required. The highest value the random number can be |
| lowerbound | Required. The lowest value the random number can be |
Technical Details
| Works in: | Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000 |
|---|
