Random Assignments

[myxmaster]

I am attempting to set up a staff rotation. Lets say I have anywhere
from 3 - 8 stations. I would like to randomly assign a name to a
station on a daily basis to assure faireness. Example:

Monday
Bill = 1
Jane = 2
Sue = 3
John = 4

Tuesday
Jane = 1
Sue = 2
John = 3

Any advise is most appreciated

[Tom van Stiphout]

On 17 May 2007 18:16:59 -0700, my*******@hotmail.com wrote:

You could select a random record by opening a recordset on the Staff
table, and then moving (rs.Move) a random number between 0 and
RecordCount-1 away from the first record. See the Rnd function in Help
for an example of how to select the random number.

-Tom.

>I am attempting to set up a staff rotation. Lets say I have anywhere
from 3 - 8 stations. I would like to randomly assign a name to a
station on a daily basis to assure faireness. Example:

Monday
Bill = 1
Jane = 2
Sue = 3
John = 4

Tuesday
Jane = 1
Sue = 2
John = 3

Any advise is most appreciated