Logical Operators Between Columns
When using logical operators between columns, you do not enter the words AND or OR in the form as you do when you use these operators in a single column. In QBF, the AND and OR operators are implied by the way the qualifying criteria is entered in the fields. Simple fields and table fields differ in how logical operators are implied:
• On a form with simple fields, the AND operator is always implied when information is entered in more than one field.
• On a form in table‑field format, the AND operator is implied when information is entered in the columns across one row of a table field.
In the following figure, for example, QBF only retrieves data from the Project and Managers tables that have the Project ID Advertise AND a Budget of more than $5,000.
• The OR operator can be implied only in table‑field format. Values in different rows of a table field are implicitly OR. In the following figure, for example, QBF can retrieve data that has the Project ID Advertise OR has a budget of more than $5,000.
