# MS Access Rnd Function

### Example

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

To return a random integer less than 1, but greater than or equal to zero:

Rnd

To return a random integer in a given range, use this formula:

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

## Parameter Values

Parameter Description
upperbound Required. The highest allowed value for the random number
lowerbound Required. The lowest allowed value for the random number

## Technical Details

Works in: From Access 2000

W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookie and privacy policy.