Assigning number to table (Not autonumber) for work distribution

I have a table full of data that I need to assign to three different individuals. So I can better track their work, I want to assign the work randomly. While in the database, the people working the records would not be in the same record at the same time and can update the records accordingly.

Ideally, I would like the first record to have a 1, the second record to have a 2, the third record to have a 3, the fourth record would have a 1 again so on until all records are assigned a 1,2 or 3.

I tried doing this in a macro, but since it can only repeat 20 times, it doesn't work. I don't know enough about VBS but I believe that is the way to do it? Any help/direction on this would be greatly appreciated.

Thanks,
Brian

re: Assigning number to table (Not autonumber) for work distribution

If they are already numbered incrementally from 1 onwards then you can mod 3 the record number to get what you need.

re: Assigning number to table (Not autonumber) for work distribution

Rabbit,

Thanks for your help on this, that did the trick.

Thanks,
Brian

re: Assigning number to table (Not autonumber) for work distribution

Not a problem. Good luck.