Query that Creates Calling List

[sting]

Hello,

I hope that someone could help me and I hope that it this question has not been posted already in the archives. Here it goes...

I have two tables (tbl1.leads and tbl2.calls)

In tbl1, I have contact information for both prospects and clients.
Every entry has a prospectid and the clients have an additional entry of a clientid. The prospects can be tagged as a referral or not.

In tbl2, I have calling information such as calldate, callback date, and whether or not the individual was contacted.

I would like to build a query that will cycle through the database with the following constraints:
1. 10 new prospects/day (Never been called)
2. 10 clients/day (Clientid)
3. 10 callbacks/day (at least) - if possible
4. 10 referrals/day, if possible

The query should create a list of individuals to call each day with at least 40 calls. If the list is short, then additional new prospects should be added. If it is longer due to the callbacks, then that is fine.

Once a prospect has been given a clientid, has agreed to an appointment, has been scheduled for a call back, or does not want to receive a call, then they should not considered a new prospect.

Can this be done?

Thanks in advance for your help, guidance and knowledge in this matter.

Sting.

 

[Mike375 No 2]

Are you looking for a query that would query your tables? If so, perhaps you could attach a cut down version of your DB.

The answer to your question "Can this be done?" will be Yes. There always is a way in Access but you need to post some details before anyone can help.

Or are you looking for a way to put a DB together for telemarketing?

 

[highandwild]

What would be the criteria for making the selections?

Purely random or is there some business logic that needs to be applied?