Feedback

  • Contents
 

Group Query Conditions

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

To group query conditions

  1. With a query window open, go to the Conditions pane.

Conditions pane - condition set

  1. Click the conditions to group.

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 designer groups the selected conditions and identifies the beginning and ending of the group.

Conditions pane - simple grouping

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

Conditions pane - complex grouping

Related Topics

Query Conditions

Queries