Flash cards
Review the key moves
1/4
Core idea
What is the main idea behind MS Access Rnd Function?
Lesson checks
Practice each idea before moving on
Short Mimo-style checks built from this lesson's code, terms, and sequence.
1Quick choice
Which statement best captures the main point of this lesson?
2Fill blank
Complete the missing token from the example code.
___ Int((10 - 1 + 1) * Rnd + 1) AS RandNumBetween1and10,3Order
Put the learning moves in the order that makes the concept easiest to apply.
The Rnd function returns a random number.
Definition and Usage
MS Access Rnd Function
Example
SELECT Int((10 - 1 + 1) * Rnd + 1) AS RandNumBetween1and10,
Int((499 - 100
+ 1) * Rnd + 100) AS RandNumBetween100and499;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:
RndTo 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 |
|---|