Loading lesson path
Concept visual
Start at both ends
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,Formula
Int((499 - 100+ 1) * Rnd + 100) AS RandNumBetween100and499;The Rnd function returns a random number.
Randomize() function before calling the Rnd function, the Rnd function may return the same random number each time!To return a random integer less than 1, but greater than or equal to zero:
To return a random integer in a given range, use this formula:
upperbound
lowerbound
Formula
+ 1) * Rnd +lowerbound )
Required. The highest allowed value for the random number lowerbound Required. The lowest allowed value for the random number
❮ MS Access Functions