Code for Random selector

  • Thread starter Thread starter Mike_B
  • Start date Start date
M

Mike_B

I would like to create a simple database of people and
after they are entered I would like to run a code that
will randomly select a name and then move on to the next
name. Once the name has been selected I will not want to
select the name again.
 
Mike,

Assign each person a sequential ID number, either using an Autonumber
field, or some other numbering procedure. Then, run a query that has
this calculated field...
SelectedPerson: Int(Max([EntryID])*Rnd()+1)

- Steve Schapel, Microsoft Access MVP
 
Back
Top