Random Numbers

  • Thread starter Thread starter SteveL
  • Start date Start date
S

SteveL

I need to create a table that consists of 1,391,991
records, numbered from 1 through 1,391,991. (Whole
numbers only). Then, 69,600 of them need to be marked in
a second field as "Winner". These 69,600 have to be
chosen at random amongst the 1,391,991 possibilities.

Any help much appreciated.

--Steve
 
i think you can make a loop, where you add records using .addnew, and Winner
generate using rnd() function
 
Back
Top