Grouping Conditional Statements

In an advanced database query, it may be necessary to not only use multiple conditions, but also to group those conditions together so that more complex searches can be performed.

• To group conditional statements
  1. Open Query Builder.
  2. Click the Conditions tab and add all conditional statements.
  3. For the first condition of the group, click +(Add) in the opening parenthesis symbol “(“ column.
  4. For the last condition of the group, click +(Add) in the closing parenthesis symbol “)” column.
  5. Repeat until all desired grouping is in place. Sublevels of grouping are possible, but may be confusing. Every subsequent condition will be applied as a sublevel of the condition preceding it.
• To remove the group from conditional statements
  1. For the first condition of the group, click (-) (Remove) next to the opening parenthesis symbol “(“.
  2. For the last condition of the group, click (-) (Remove) next to the closing parenthesis symbol “)”.
  3. Modify connectors as necessary.