[AccessD] Last Date Query

I think what you want is this:

SELECT TOP 1 tbl1.Pat, tbl1.Date AS LastDate, tbl1.Result
FROM tbl1
ORDER BY tbl1.Date DESC;

HTH,
Arthur

On Thu, Dec 22, 2011 at 7: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
>



-- 
Cell: 647.710.1314

Thirty spokes converge on a hub
but it's the emptiness
that makes a wheel work
   -- from the Daodejing