Last updated: August 26, 2026.
The Rnd function returns a pseudo-random Single value greater than or equal to zero and less than one.
Syntax
Rnd[(number)]| Argument | Description |
|---|---|
number | Optional numeric expression controlling the generated sequence |
Examples
Randomize
Roll: Int(6 * Rnd + 1)
ValueInRange: Int((100 - 10 + 1) * Rnd + 10)Call Randomize once before generating ordinary random values. Rnd is suitable for simulations and UI choices, not passwords, tokens, or other security-sensitive values.
See Microsoft’s Access function reference for related expression functions.
