Retreiving records by last date

[Bronte1226]

I need to create a query that will select the record with the last date (most recent) entered. How do I do this?

 

[PHV]

SELECT A.*
FROM yourTable A INNER JOIN (
SELECT Max([Date field]) AS LastDate FROM yourTable
) B ON A.[Date field] = B.LastDate;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886