Creating Queries with Comparison and Logical Operators

Creating Queries with Comparison and Logical Operators

You can use the Expression Builder to create more complicated queries. For example, you can use comparison operators , such as >, <, or =, to compare field values to constants and other field values. For example, you can use the greater-than operator (>) to create a query that retrieves records in which more than 1 toy is ordered. You can also use logical operators to create criteria combining several expressions. For example, you can use the AND operator to retrieve records in which the number of toys ordered is greater than 1 AND less than 5. You can also use logical operators to negate expressions. For example, you could run a query that retrieves toy records that are NOT infant toys.

Use a Comparison Operator

Display the query in Design View, and then click the Criteria box for the field.

Click the Build button on the Query Design toolbar.

Click the appropriate comparison operator button.

To see additional comparison operators, click the Operators folder, click Comparison, and then choose the comparison operator you want from the list on the right.

Enter a value or click a field whose value you want to compare.

Click OK.

Click the Run button on the Query Design toolbar.

Use a Logical Operator

Display the query in Design view, and then click the Criteria box.

Click the Build button on the Query Design toolbar.

Click the appropriate logical operator button.

To see additional comparison operators, click the Operators folder, click Logical, and then choose the logical operator you want from the list on the right.

Enter any values needed to complete the expression.

Click OK.

Click the Run button on the Query Design toolbar.

Did You Know?

You can fine-tune selection criteria . To fine-tune your selection criteria, combine logical and comparison operators in the same expression.

You can compare one field with another . To create an expression that compares one field with another, use the Expression Builder and look within the Tables folder to locate the table and field of interest. Double-click the field name to add it to the expression. The expression should contain the table name and field name in brackets, separated by an exclamation point. For example, to choose records where the value of the OnOrder field in the Orders table is greater than the value of the InStock field, the expression is: [Orders]![OnOrder]>[Orders]![InStock] .