Date related Query- help please!

[Lucy02]

Hi there,

I have a table which shows telemarketing that has been completed on a weekly basis where the caller places the date they called in one field and a followup date (if needed) into another field if a followup call needs to take place.

I want to create a query which will show me all calls that have got a followup date put inplace but the followup call has not been made.

E.g i call mum on 29/11/06 i put down followup on 30/11/06. I call on the 30/11/06 so the followup has been completed but need to follow up again on the 01/12/06 but i do not complete this one.

Any ideas???

Thanks

 

[Matt Greatorex]

What is the table structure? I'm trying to picture how you're storing the callback info.

I would guess a query that asks for all names where there is a callback date and where the callback date isn't in the list of all calls made for that same person?

 

[JustinDB]

posible solution

i have made the support database for my company if you want you van buy it and i will change it for a small price let me know

 

[Lucy02]

Matt,

the table is as follows:

caller id, company called, date of call, result, followup call date

So ideally if caller id 1 calls "Mum" on 1/12/06 and her followup call date is 02/12/06 then there should be another call entered into the table on the 2/12/06 from caller id 1 to "Mum" which proves that the followup call was completed if that makes sense?

Thanks

Lucy