Random Number Generator

[GreenFella]

I was hoping to generate Random numbers within Access VBA but was unsure of how to go about this.

The RND() function does not do the trick. Nor did the RANDOMBETWEEN function.

Any light that can be shed would be greatly appreciated.

Thanks
Greenfella

 

[MichaelRed]

GreenFella

the Ubiquitous [[b{F1} (aka HELP)provides sufficient info on both function for any 'professional'.





MichaelRed
mlred@verizon.net

 

[sfreeman]

Did you try something like:

Public Function Rand()
Dim MyValue
Randomize
MyValue = Rnd()
MsgBox MyValue
End Function

 

[GreenFella]

Thanks for your help sfreeman.

That did the trick.

My Ubiquitous [[b{F1} (aka HELP) didn't list any details regarding Randomize or RND().

Guess the full help guide isn't installed on this machine.

Greenfella