You can't assign them randomly AND evenly, but you could employ elements of both. Why not just cycle them between the reps (ABCABCABC)? Don't the leads arrive "randomly" for all practical purposes? Otherwise you'd have to write an algorithm that switches between random and "catch up" for those have been cheated by the random assignment. But why???
-Tim -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lisa Sent: Sunday, October 21, 2007 7:43 AM To: [email protected] Subject: [Access VBA Central] Assigning names to records randomly Hopefully someone has a solution for me. I receive sales leads on a daily basis and I need to assign those leads to our inside sales reps randomly. I have tried different approaches, but it doesn't distribute the leads evenly (one person may get 6, while the next person only gets 2). Thanks.
