Re: Select Most Recent Date for Record



T M wrote:
> I would like to my query to display the record that has the most
> recent date (sorted in the query). Is it possible to just display one
> record? If yes, please show me what to do.
>
> Thanks!

SELECT TOP 1 .... ORDER BY YourDateField DESC

In the graphical query designer just open the property sheet and enter 1 for
the "Top Values" property and sort on your date field in descending order.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.