How can I generate random numbers in Access 2000?

  • Thread starter Thread starter Lorne
  • Start date Start date
L

Lorne

I wish to be able to have fields that will show random numbers for a game
design. Is there a viable way to do this inside Access 2000?
 
ho Lorne,
I wish to be able to have fields that will show random numbers for a game
design. Is there a viable way to do this inside Access 2000?
Click to expand...
Take a closer look at the properties of the data type auto-number...


mfG
--> stefan <--
 
I wish to be able to have fields that will show random numbers for a game
design. Is there a viable way to do this inside Access 2000?
Click to expand...

What constraints on the random numbers? The Rnd() function will return random
double floats greater than or equal to 0 and less than 1, and can be used to
generate other types (e.g. 1 + 1000*Rnd(somefield) will generate integers
between 1 and 1000). You do need to pass Rnd() some positive integer argument
in a Query otherwise Access will call it only once.
 
Back
Top