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

Access 2003: Even distribution

P: 24
Hi All,

I was wondering how do I evenly distribute a list of accounts among 4 users. I understand based on the number of records it is not always going to be evenly distributed. Is there a statement that can be entered in the criteria of a query. I originally did it by alpha split but that doesn’t work that well. Thank you for any suggestions.
Oct 8 '07 #1
Share this Question
Share on Google+
3 Replies

Expert 2.5K+
P: 3,072
When you desing an autonumber as the ID, you can use a query with the MOD statement like:
Expand|Select|Wrap|Line Numbers
  1. select [Id] Mod 4 + 1AS PartNo, ...
Now a field containing 1, 2, 3, 4, 1, 2, 3, 4, 1, ..... will be added.
Based on this query you can create a grouped report allowing you to have 4 different sections with equally distributed rows.

Getting the idea ?

Oct 8 '07 #2

P: 24
Hi nico5038,

Thanks for the input, I wasn't familiar with MOD statements but did some reading on it and I was able to figure it out. Thanks again for your guidance, you guys are great!
Oct 8 '07 #3

Expert 2.5K+
P: 3,072
Glad I could help, success with your application !

Oct 8 '07 #4

Post your reply

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