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