Hmmm...general approach I would use is this: Assuming you have X # of sales reps.
Put them in a list. If a lead comes in, assign it to a randam rep in the list. Remove them from the list. Repeat with every new lead. When the list is at zero, repopulate it with all of the sales reps. > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] Behalf Of Lisa > Sent: Sunday, October 21, 2007 5: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. > >
