As a website designer, I can say you have one of the best learning websites.”

Online Learner

Creating Opportunities For A Better Life.®

Access XP

Single page view print copy

Filtering Records

Performing a Filter Excluding Selection

The Filter Excluding Selection works in the opposite manner as the Filter by Selection. Instead of specifying the filter to be used to view records (e.g., everybody in North Carolina), Filter Excluding allows you to view data that does not include the specified criterion (e.g., everybody not in North Carolina).

To Apply Filter Excluding Selection:

  • Click anywhere in the field that is to be excluded from the filter.

    Select Field To Be Used in Filter
  • Choose RecordFilter Excluding Selection from the menu bar or right-click and choose Filter Excluding Selection from the shortcut menu.

    Filter Excluding Selection option under the Reports Menu
  • All records except the criterion you excluded are now visible.

    Filtered Records
  • The status area shows only the filtered records displayed on the screen.

Remove this filter by clicking the Remove/Apply Filter button.

1 2 3 4 5 6 7