J
John Spencer
DId you try changing the = to >= or just >?
SELECT I.CountryCode, I.CustID, I.Specialist, I.ReviewDate, I.Activity,
I.DealerCode, I.AuditNo
FROM Itinerary AS I
WHERE I.ReviewDate > (
SELECT Max(ReviewDate) AS LastDate
FROM Itinerary as X
WHERE X.Activity = "Audit" and X.CustID = 3
AND X.CountryCode = I.CountryCode
AND X.DealerCode = I.DealerCode)
When something does not work quite the way you wish it to try experimenting a
bit. You'll learn more, are more likely to retain the solution, and are more
likely to be able to apply the concept in the future.
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
SELECT I.CountryCode, I.CustID, I.Specialist, I.ReviewDate, I.Activity,
I.DealerCode, I.AuditNo
FROM Itinerary AS I
WHERE I.ReviewDate > (
SELECT Max(ReviewDate) AS LastDate
FROM Itinerary as X
WHERE X.Activity = "Audit" and X.CustID = 3
AND X.CountryCode = I.CountryCode
AND X.DealerCode = I.DealerCode)
When something does not work quite the way you wish it to try experimenting a
bit. You'll learn more, are more likely to retain the solution, and are more
likely to be able to apply the concept in the future.
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County