By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,871 Members | 2,575 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,871 IT Pros & Developers. It's quick & easy.

Iterate Through a List

P: 1
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!
Jan 7 '10 #1
Share this Question
Share on Google+
3 Replies


ADezii
Expert 5K+
P: 8,637
Kindly describe the nature of this 'List', providing some sample entries.
Jan 7 '10 #2

NeoPa
Expert Mod 15k+
P: 31,489
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.
Jan 7 '10 #3

nico5038
Expert 2.5K+
P: 3,072
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)
Jan 10 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.