QUERY SYNTAX IS NULL BETWEEN

[maeling]

Hello,
I have a query I am trying to get to work and can't quite work it out.
I have a date field called visit_date. Everytime one of my users visits a customer he enters record and the date for the record is create =date()
I would like to query for customers taht have not had a visit for the last three months ? Can I do this ?

 

[PHV]

Perhaps something like this ?
SELECT CustomerID, Max(visit_date) As LastVisit
FROM yourTable
GROUP BY CustomerID
HAVING (Max(visit_date)<Date()-90) OR (Max(visit_date) Is Null)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886