Bug in RND() function?

[Robeen]

Hi,
I ran a program at work that required two random names be pulled on five different days from a set of about 250,000 names.
The names are appended into a table from 5 different spreadsheets.
The RND function is run using the high & low values from the ID [Auto Number] field.
This is my code to get the random number:

intRandom = Int((intUpper - intLower + 1) * Rnd + intLower)

On each of the days - the first number pulled at random had a Last Name beginning with "P" and the second number pulled had a LAst Name beginning with "L".
I didn't spot the pattern - [I wasn't looking for a pattern at that point] -but when the Director for whom I did this program was typing up the report of all the names drawn on the 5 different days - the pattern was unmistakable.

Can anyone think of what might have happened?



I tried to re-create the problem and am not able to now.

I should add that before the Form comes up with the button to click for the random names - three macros run:
1. Delete existing data,
2. Import data from spreadsheets
3. Append data from spreadsheet imports to 'master' table.

The last macro action is to open the Form.

I'd appreciate any ideas/suggestions.

[hertfordkc]

In describing RND, the initialization is barely mentioned, but for most applications, it is essential.

[Robeen]

Thanks, hertfordkc.
This pointed me in the right direction - and I have a much better understanding of the RND() function in Access now than I did before.
Your pointer led me indirectly to the Randomize statement in VBA and that has solved the problem.
Thank you!