Random Numbers

[klyon]

Hi All -

I'm looking for a way to add a random number field to an existing table in Access 2000.

I've not been successful with the rand or random functions.

Thanks,

-Kris

 

[SgtJarrow]

Although at first glance I found the below to be top heavy (produced more higher numbers than lower ones), after much testing and usage it appears to be right on target....

Randomize
somevariable = Int((9-0+1)*Rnd+0)

will give you a random number between 0 and 9.....adjust the ends as necessary. Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III, MCP, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com

 

[SgtJarrow]

One more note....you should always include a randomize statement either directly before or directly after every Rnd call....I choose to put it before very call.....this will reseed the random list at every call.... Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III, MCP, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com