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