I think it is more efficient to use an SQL query which retrieves only the records you are interested in (especially if you have a large database), example:
SELECT * FROM Orders
WHERE OrderDate BETWEEN #07/04/1996# AND #07/09/1996#;
Then you can use an sql datareader to loop through the results, see example here:
[
^]