Code for Random selector

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

 

[Steve Schapel]

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