Multiple Conditions



 


2 Conditions - Greater Than AND Less Than

Condition 1 - Age must be greater than 23
Condition 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 22
Condition 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 table
Condition 1 - Age can be greater than 23
Condition 2 - Salary must be greater than 35000
Condition 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 23
Condition 2 - Salary must be greater than 35000
Condition 3 - Age can be less than 23


 


4 Multiple Conditions - Condition1 OR Condition 2 OR Condition 3 OR Condition 4

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


 



© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top

PrevNext