Why not just have a sql query do it for you.
SELECT Max(Field_Name) AS MaxofField_Name FROM Table_Name;

"gab1972" wrote:

I found some coding to find a date range in an Access recordset, but I
need a macro to search a recordset for the oldest date.

Any help or references would be greatly appreciated...or even a place
to start. My recordset name is rs.

Thanks in advance! I love this community. It's saved my a$$ numerous
times.
.