We will just repeat what was said about logical operators in chapter 26 “Searching records in a table” practically without any changes.
When specifying group condition two logical operators can be used: “AND” and “OR”.
Group condition consisting of two simple conditions combined by logical operator “AND” is considered to be true if both simple conditions are true, it is considered to be false if at least one of them is false.
Group condition consisting of two simple conditions combined by logical operator “OR” is considered to be true if at least one simple condition is true, it is considered to be false if both simple conditions are false.
Logical operator “AND” has a higher priority than the logical operator “OR”. It means that group condition:
sc1 OR sc2 AND sc3,
where sc is a simple condition, will be calculated in the following way:
sc1 OR ( sc2 AND sc3 ).
If another evaluation order is required, parentheses should be used explicitly, for instance:
( sc1 OR sc2 ) AND sc3.
 |  |
