Gary Kjos
garykjos at gmail.com
Thu Dec 22 08:03:57 CST 2011
Remove the tbl1.Result from the Group By so you only group by Pat. GK On Thu, Dec 22, 2011 at 6:35 AM, <pedro at plex.nl> wrote: > > 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 > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- Gary Kjos garykjos at gmail.com