Random Numbers

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
 
A

Alex Dybenko

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RANDOM NUMBERS 2
Page numbering with Merged Document and IF statements 1
Finding the proper style field and the numbered paragraph value within the style 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Copy and Paste x amount of times. 0
Random Number of Long 7
MACRO RUN random percentage and copy of column values 1
OneNote and MS Forms 0

Top