select only 1 record based on 1 criteria

  • Thread starter Thread starter Gerry
  • Start date Start date
G

Gerry

My query results in a series of records. One of the fields contains a
date.
I'm only interested in 1 record, namely the one corresponding to the
latest date.
Can you help me?
 
Try this ---
SELECT YourTable.*
FROM YourTable
WHERE (((YourTable.YourDate)=(SELECT Max(YourDate) FROM YourTable as
Temp )));
 
Back
Top