Grouping query filters
You can group filters in the Filter Criteria list using the logical operators AND and OR. Use the Query editor or the Query wizard to group query filters to create complex filters.
About this task
To group query filters:
Procedure
- In the Filters pane of the Query editor
or the Query wizard, select and right-click a filter to add to
the group or to be the container for other filters in the group? group,
and click Group.A dimmed rectangle appears as you move the mouse in the Filters pane.
- Click a filter with which to group the filter that you selected
in Step 1.The filter group appears in the Filters pane, nested under the appropriate And and Or operators.
- To add more filters, drag each filter over the And or Or operator associated with the group.