Any ideas for flagging 20% of leads for sales offices?

[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
sales location (based on zip code) so telemarketing knows which offfice to
assign it to.

Now 20% of those leads must go to the 30 different sales locations for the
salespeople to call.

I can't think of any simple way to randomly extract 20%
from each location for sales...does anyone have any ideas?


i.e.
Location Tot Leads Telemarketing Sales
Philadelphia 1000 800 200
Atlantic City 500 400 100

Thank you for any thoughts
holly

 

[Steve Schapel]

Holly,

What do you mean by random? If the records as entered into the database
are already in no particular order, then they are already random... is
that the case? So you could just take the first 20% (using the TOP
predicate in your query), and it would be random by definition, no?
Otherwise, do the records have an incremental ID number or somer such,
which you could use as the basis of an "every 5th record" process?

 

[Holly]

Steve,

Yes just 20% random would not be too hard.....but I have to assign them to a
sales location and then hold 20% from each location? So that involves
calculating percentages for 30 different locations, you know?

Holly

 

[Steve Schapel]

Holly,

In your Query, in the Criteria of the applicable (e.g. [ID]?) field, put
the equivalent of...

In(SELECT TOP 20 PERCENT [ID] From YourTable WHERE
[Location]=[YourTable].[Location])