6. MICROSOFT ACCESS QUERIES – ADVANCED
If one specifies multiple criteria on both the Criteria and Or lines the criteria on each line is ANDed, and those evaluations are then ORed. If for some row either one or both of the sub-expressions evaluate to true, then the row will be selected for display.
Suppose we need a list of all ACS courses that are 3 or 6 credit hour courses. Logically we can express this as:
(deptCode=”ACS” AND creditHours=3)
(deptCode=”ACS” AND creditHours=6)
We code this in QBE as: