Access 2003 In Pictures

When should you filter?

Filtering records works like a query, bringing up specific information from a table.

But unlike a query, your filtering doesn't remain part of the database.

When you perform a query and save it, the query remains with the database, even after you close it. Filtering does not.

Since you can't save filtering like a query, filter records when you need quick results. Think of filtering as a temporary, quick, "on the spot" query.