6. MICROSOFT ACCESS QUERIES – ADVANCED
If one specifies multiple criteria on one line in the Grid area, these criteria are ANDed. For a row to contribute to the result of the query the row must satisfy all the criteria.
Suppose we want a list of all ACS 3 credit hour courses. We need to obtain the rows in Course where the logical expression
(deptCode=”ACS”) AND (creditHours=3)
is true. We code this in QBE as: