How can I generate random numbers in Access 2000?

[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?

 

[Stefan Hoffmann]

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?

Take a closer look at the properties of the data type auto-number...


mfG
--> stefan <--

 

[John W. Vinson]

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?

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.