R
rob
using Access, between say 100025 and 986523
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Randy Harris
rob said:using Access, between say 100025 and 986523
This is right out of the Access help:
Before calling Rnd, use the Randomize statement without an argument to
initialize the random-number generator with a seed based on the system
timer.
To produce random integers in a given range, use this formula:
Int((upperbound - lowerbound + 1) * Rnd + lowerbound)
Here, upperbound is the highest number in the range, and lowerbound is the
lowest number in the range.
A
AlCamp
Rob,
MyValue = Int((986523 * Rnd) + 100025)
hth
Al Camp
MyValue = Int((986523 * Rnd) + 100025)
hth
Al Camp
R
Randy Harris
AlCamp said:Rob,
MyValue = Int((986523 * Rnd) + 100025)
hth
Al Camp
Needs a tweak. That could give him a number greater than 986523.
G
Guest
-----Original Message-----
This is right out of the Access help:
Before calling Rnd, use the Randomize statement without an argument to
initialize the random-number generator with a seed based on the system
timer.
To produce random integers in a given range, use this formula:
Int((upperbound - lowerbound + 1) * Rnd + lowerbound)
Here, upperbound is the highest number in the range, and lowerbound is the
lowest number in the range.
.great, thanks alot~ cheers rob
G
Guest
-----Original Message-----
Rob,
MyValue = Int((986523 * Rnd) + 100025)
hth
Al Camp
Al, thanks very much ~ Rob
.