Hi Everyone
I've recently come up against a date issue in a query and I am wondering if anyone can help me I've tried several different ways and I'm not getting the result I'd hope for.
What I am trying to do is cross check all the records and only isolate the most current date for each record.
I have this so far
SELECT Max(tClientClosure.Closuredate) AS MaxOfClosuredate, tClientClosure.ClientID
FROM tClientClosure
GROUP BY tClientClosure.ClientID;
It should be a simple query right? Whilst I can get this to run a query when I try and put get a field in a form to look at the particular record data it shows up blank... every other query I have done and implemented has worked this one isn't and it is driving me nuts. :bangheadlease help!! Thanks in advance..
I've recently come up against a date issue in a query and I am wondering if anyone can help me I've tried several different ways and I'm not getting the result I'd hope for.
What I am trying to do is cross check all the records and only isolate the most current date for each record.
I have this so far
SELECT Max(tClientClosure.Closuredate) AS MaxOfClosuredate, tClientClosure.ClientID
FROM tClientClosure
GROUP BY tClientClosure.ClientID;
It should be a simple query right? Whilst I can get this to run a query when I try and put get a field in a form to look at the particular record data it shows up blank... every other query I have done and implemented has worked this one isn't and it is driving me nuts. :bangheadlease help!! Thanks in advance..