[AccessD] Last Date Query

pedro at plex.nl pedro at plex.nl
Thu Dec 22 12:35:38 CST 2011


Hello Group, i want the last dat from tbl1

Pat     Date       Result
A1     01-01-11    15
A1     10-10-11     7
A1     11-11-11     6

When i use the query: 

SELECT tbl1.Pat, Last(tbl1.Date) AS LastDate, tbl1.Result
FROM tbl1
GROUP BY tbl1.Pat, tbl1.Result;

Then is stil have these three records because of the Result

What i need is only record that is really the last date, regardless what value there is for result

Pat     LastDate         Result
A1     11-11-11           6


I have done this before, but i can't remember how.
Is has to been done with a subquery.

Who can help me?

Thanks

Pedro



More information about the AccessD mailing list