Filtering Records

In Access XP filtering records may seem confusing at first. This free lesson offers step-by-step instructions.

Removing a filter

To remove a filter:

  • Click the Remove Filter button on the Standard toolbar, or choose RecordsRemove Filter/Sort from the menu bar.

    Remove Filter/Sort option in the Records Menu
  • The records revert to their ordering before the sort was applied.

    Sort Order When Filter Removed
  • If you want to reapply the filter, click the Apply Filter button (this button acts like a toggle to turn the filter on and off).