Assigning number to table (Not autonumber) for work distribution

[Locoman]

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

[Rabbit]

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

[Locoman]

Rabbit,

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

Thanks,
Brian

[Rabbit]

Not a problem. Good luck.