In some cases, you already have a recordset, but you need to operate only on some records. You can, of course, iterate on the recordset, checking for the condition on each iteration and acting depending on the result of the check. It can be easier, and in some cases, more efficient, to construct a new recordset containing only the interesting records and calling a single operation on that recordset.

This recipe shows how to use the filter() method to extract a recordset from another one.