Obtains a random whole number between 1 and a specified upper limit.
Rand ( n )
Argument  | 
Description  | 
|---|---|
n  | 
The upper limit of the range of random numbers you want returned. The lower limit is always 1. The upper limit cannot exceed 32,767.  | 
A numeric datatype, the datatype of n. Returns a random whole number between 1 and n.
The sequence of numbers generated by repeated calls to the Rand function is a computer-generated pseudorandom sequence.
This expression returns a random whole number between 1 and 10:
Rand(10)