H
Holly
Aggg...I am stuck....
I get a thousands of new sales leads each week that I process in access and
forward to a telemarketing dept - I code each lead with a geographical
location (based on zip code).
Now 20% of those leads must go to 30 different sales locations for the
salespeople to use - I can't think of any simple way to randomly extract 20%
from each location for sales...does anyone have any ideas?
Location Total Leads Telemarketing
Sales
Philadelphia 1000 800
200
Atlantic City 500 400
100
Thank you for any thoughts
holly
I get a thousands of new sales leads each week that I process in access and
forward to a telemarketing dept - I code each lead with a geographical
location (based on zip code).
Now 20% of those leads must go to 30 different sales locations for the
salespeople to use - I can't think of any simple way to randomly extract 20%
from each location for sales...does anyone have any ideas?
Location Total Leads Telemarketing
Sales
Philadelphia 1000 800
200
Atlantic City 500 400
100
Thank you for any thoughts
holly