select only 1 record based on 1 criteria

[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?

 

[KARL DEWEY]

Try this ---
SELECT YourTable.*
FROM YourTable
WHERE (((YourTable.YourDate)=(SELECT Max(YourDate) FROM YourTable as
Temp )));