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