Issue with time query

[Reynardine]

Hi Guys,

I was wondering if anyone here would be able to help me with a problem I am having.

I have a query which is based on a table which has 4 feilds in which if a customer has been called within a certain date range it presents it.

So the 4 feilds are:

Call 1 Date
Call 2 Date
Call 3 Date
Call 4 Date

I want it to present these records if call 1 Date is More than 2 days ago. If call 2 Date is more than 2 days ago, and the same with 3 or 4. However I also want it to only look at the call date on the most recent feild...if that makes sense? Otherwise if they have already have a call 1 date, its always going to be 2 days after that for any future calls. However, I want it to call them after 2 days since the last call.



So it ends up being a system whereby The customer gets a call every 2 days until the issue is finally resolved (unless it has happened 4 times), in which we will close it.

I hope I have managed to explain myself, and would appreciate any held or guidance you could provide me?

[orange]

You should review Normalization.
It appears that you should be using 2 tables (I may not fully understand your issue however)

Customer---->PhoneCalls

Customer would have fields such as

CustomerId (PK)
CustomerFirstname
CustomerLastname
CustomerPhoneNo
... other Customer specific fields

PhoneCalls

PhonecallId (PK)
CustomerPhoneNo (FK to Customers)
CallDate
...other fields related to a specific customer call

This structure will facilitate queries to "get" the info you need.

[Reynardine]

Thank you.

So even if I did that and had a table with just the call time and outcomes with the customer ID being the PK, how would I query it to meet the criteria I provided?