Search not resulting in expected outcome

[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

 

[hughess7]

Sorry I should have thought to try that! Too much on my plate at the mo as
I'm trying to develop (whilst learn!) a web app in .net too and I am the only
IT person in the company I work for - needless to say I'm struggling ;-).

I do normally experiment etc, I had already changed Doug's etxra ON's to
AND's but I missed the alias bit.

Thanks again,
Sue