Iterate Through a List

[Tyro]

I have built a database that is updated daily with new items. Each new item needs to be given to someone on our team to work on. I would like to automatically assign the new items to the team members identified on a list and iterate through the list so that the work is distributed evenly.

Thanks for any help!

[ADezii]

Kindly describe the nature of this 'List', providing some sample entries.

[NeoPa]

This would not suit a SQL approach.

Luckily you already have the interest of one of our experts who's very experienced with RecordSet programming.

[nico5038]

Make sure a sequence number has been added to the employee list, starting with 0.
Next use the MOD() function on the (autonumber in sequence) ID of the news items with the number of employee's as the "base value" so the remainder (c.q. result) of the mod function will hold a value between 0 and the highest employee sequence number.

Getting the idea ?

Nic;o)