Multiple Conditions

2 Conditions - Greater Than AND Less Than

Condition 1 - Age must be greater than 23Condition 2 - Age must be less than 26

2 Conditions - Equals OR Equals

When you want to specify an OR operator you must place the conditions on separate rows.Condition 1 - Age can be equal to 22Condition 2 - Age can be equal to 26

2 Multiple Conditions - Condition1 OR Condition2

When you want to specify a combination of OR and AND operators you must place the conditions in a tableCondition 1 - Age can be greater than 23Condition 2 - Salary must be greater than 35000Condition 2 is the same as saying Age < 23 and Salary > 35000

3 Multiple Conditions - (Condition1 AND Condition3) OR Condition3

Condition 1 - Age can be greater than 23Condition 2 - Salary must be greater than 35000Condition 3 - Age can be less than 23

This will display all the rows that meet any of the four conditionsCondition 1 - Age can be greater than 23Condition 2 - Age can be less than 23 but Salary must be greater than 35000Condition 3 - Age can be less than 23 and Salary is less than 35000 but Date must be greater than 14 MayCondition 4 - Age can be less than 23 and Salary is less than 35000 and Date is less than 14 May and Volume < 50