What would be faster in terms of procedure excecution time?
Select all 3000 records in 1 recordset and loop through them in VBA and do a Select Case on some field for each record. If value is A then do some statements or if value is B then do some other statments
Select all 3000 records in1 recordset and set a filter on some field to value A and loop through all records and do some statments and then reset the filter on some field and set te value to B and do some other statments
Select all records in 1 recordset with some field having value A and do some statements and then clear the recordset and reselect all records in 1 recordset with some field having value B and do some other statments
Also please explain why you thins that is