6. MICROSOFT ACCESS QUERIES – ADVANCED

6.1.2: Or

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.

 

Example

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)

OR

(deptCode=”ACS” AND creditHours=6)

We code this in QBE as:

image
                          Figure 6.2: Two expressions that are ORed

License

Icon for the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License

Relational Databases and Microsoft Access 365 Copyright © by Ron McFadyn is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.

Share This Book