Once a filter exists for data in your query or results, you can later add or modify filter conditions.
To modify a filter:
Select the column to which the filter has been applied.
Select Filter on the shortcut menu.
The Filter submenu is displayed.
Select Apply/Modify on the Filter submenu.
The Filter window is displayed.
Select the filter value and click Set.
The following table provides a quick reference to the Modify Filter option:
Command
Description
Set
Applies the filter value.
Ignore Filter
Ignores a filter without deleting it.
Cancel
Cancels any filter applied in the current sessions.
To modify a filter: