By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,045 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

Random Assignments

P: n/a
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

May 18 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
May 18 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.