I have a collumn filled with dates. How would I go about selecting the record with the most recent date.
using access 2000.
thanks!
using access 2000.
thanks!
-
-
Re: most recent date
On Tue, 17 Aug 2004 13:34:05 GMT, <jjrmy1@earthli nk.net> wrote:
[color=blue]
> I have a collumn filled with dates. How would I go about selecting the record with the most recent date.
> using access 2000.
> thanks![/color]
Where? In a Query?
Where [DateField] = DMax("[DateField]","TableNam e")
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
-
Re: most recent date
jjrmy1@earthlin k.net wrote:
[color=blue]
> I have a collumn filled with dates. How would I go about selecting the record with the most recent date.
> using access 2000.
> thanks![/color]
Select top 1 * from table order by datefield;
Comment
-
Re: most recent date
Trevor Best wrote:
[color=blue]
> jjrmy1@earthlin k.net wrote:
>[color=green]
>> I have a collumn filled with dates. How would I go about selecting the
>> record with the most recent date.
>> using access 2000.
>> thanks![/color]
>
>
> Select top 1 * from table order by datefield;[/color]
Sorry, "order by Datefield DESC;"
Comment
Comment