PDA

View Full Version : Date Search


Shawn
May 28th, 2004, 04:06 PM
I have a query and I would like to look up the record with the most current date.
Is there a way to do this?
Thanks in Advance
Shawn

Brian Camire
May 28th, 2004, 04:13 PM
You might try a query whose SQL looks something like this:

SELECT TOP 1
[Your Table].*
FROM
[Your Table]
ORDER BY
[Your Table].[Your Date Field] DESC

"Shawn" > wrote in message
...
> I have a query and I would like to look up the record with the most
current date.
> Is there a way to do this?
> Thanks in Advance
> Shawn

Google