Marking records for different users

srbooth

Registered User.
Local time
Today, 21:10
Joined
Feb 11, 2007
Messages
24
Is there a way where I can take records in a table and split them by dividing them among three users. In other words, issue a unique operator number 1,2,3 to a field in the records table that would share all the records by the three operators, randomly.

Thanks
 
Create a query of the table adding a column with a random number, then requery that query, ordered by the random number column, assigning the records sequentially to the different users.
 
The first bit sounds straight forward for randomizing the records, but how do I assign the operator number to each record making sure each of the three operators gets an equal amount of records. The operator field is left blank waiting for it to be completed.

Thanks
 

Users who are viewing this thread

Back
Top Bottom