Access 2016 Intermediate

Lesson 3 – Using Operators in Queries

Access 2016

NOTE The Between And operator is inclusive; all records with values that include or fall between the stated criteria are included in the recordset. Use the Expression Builder by selecting the Criteria row and, on the Ribbon in the Design tab Query Setup group, click the Builder button. Spaces must be included between the criteria and the words Between and And . If you do not include the proper spacing, the Data type mismatch in criteria expression error message appears.



Procedures

1. Open the desired query in Design view. 2. Select the Criteria row of the desired field. 3. Type Between , the first value in the range, And , and the last value in the range. 4. Press [Enter] .



Step-by-Step

Use the Between And operator in a query.

If necessary, open the CSales Query query in Design view and delete any previous criteria.

Steps

Practice Data

1. Select the desired field’s Criteria row. The insertion point appears in the corresponding Criteria row. 2. Type Between , the first value in the range, And , and the last value in the range. The operator and the criteria appear in the Criteria row.

Click in the Credit Limit field Criteria row

Type between 1000 and 2000

3. Press [Enter] .

Press [Enter]

The Between And operator and the criteria are added to the design grid.

Page 60

OFFICEPRO, Inc.