[AccessD] Last Date Query

Agreed.  Assuming you mean the most recent date, i.e. Max rather than Last, 
then Arthur's suggestion is how I would do it.

Regards
Steve

-----Original Message----- 
From: Arthur Fuller
Sent: Friday, December 23, 2011 1:05 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
> --