One other thing...can I add an AND statement in there?

The criteria should be that I need to find in the recordset
permit_info the permit number (field = permit_num) with the smallest
date (field = permit_log_date) and does not equal "Applicant" in the
field curr_location.

Mike wrote:
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.
.