Feedback

  • Contents
 

Group Query Conditions

Use the Conditions pane to separate conditions into groups when you require complex data mining.

To group query conditions

  1. With a query tool window open, in the Conditions pane, click the conditions to group.

Query Designer Report Form window - Conditions pane

Tip: To select multiple sequential conditions, press and hold the Shift key and click the first and last sequential condition. To select multiple non-sequential conditions, press and hold the Ctrl key and click each individual condition. To select all conditions, right-click and then click Select All.

  1. Do one of the following:

    • In the toolbar, click the Group icon.

    • Right-click the selected conditions and then click Group.

The query tool groups the selected conditions and flags the beginning and ending of the group.

Query Designer Report Form window - Conditions pane - simple grouping

  1. Continue grouping conditions as necessary. The following example shows a complex grouping of conditions.

Query Designer Report Form window - Conditions pane - complex grouping

Related Topics

Query Conditions

Queries