Modifying the logical operator between qualifications

To change the logical operator, you must first create two or more qualifications for either the WHERE clause or the HAVING clause. Once you create the two qualifications they are separated by the logical operator AND by default. To change the logical operator, click the logical operator and select one of the following logical operators:

• AND: Returns as true if both qualifications are evaluated as true.

• OR: Returns as true if at least one of the qualifications is evaluated as true.

• AND NOT: Returns as true if the first qualification is evaluated as true and the second qualification is evaluated as false.

• OR NOT: Returns as true if the second qualification is evaluated as false or if the first qualification is evaluated as true. This operator returns as false only if the first qualification is false and the second qualification is true.

If two or more logical operators separate qualifications in the Conditions pane (the middle pane on the right), you can perform the following tasks:

• Increase indent: indents the selected operator and its associated qualifications to the right. For example, two qualifications are connected through the AND operator. If you select the AND operator and select the Increase indent option, it moves the two qualifications along with the operator to the right.

• Decrease indent: indents the selected operator and its associated qualifications to the left. For example, two qualifications are connected through the AND operator. If you select the AND operator and select the Decrease indent option, it moves the two qualifications along with the operator to the left.

Related Topics

• Creating a security filter in Query Builder

• Removing a qualification