getting min and max values from filtered recordset

Hi, I have a recordset that I am filtering by a certain criteria.
Does anyone know if there is a better way to retrieve the minimum and maximum values of a field rather than;

Redo the database query
Go through each record in the recordset comparing the current value to the previous value?

Thanks in advance
MarkusJ

There is no way that I know of, Let me know if there is a different way.