By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 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,597
Kindly describe the nature of this 'List', providing some sample entries.
Jan 7 '10 #2

NeoPa
Expert Mod 15k+
P: 31,186
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.