rst.Filter = "field1>=#" & variable1 & "# AND field1<=#" & variable2 & "#"After the filter is set you should have a lower recordcount, and you can loop to EOF() with only the rows that match the filter. If you have an error message, be sure to include it on your response.