In Access 2000 filtering records may seem confusing at first. This free lesson offers step-by-step instructions.
If you want to see all data in a form or table except for a certain criterion, use Filter Excluding Selection.
Remove this filter by clicking the Remove/Apply Filter button.
All sorting and filtering commands are available in the Records menu (on the menu bar) and on the shortcut menu.