Access 2016 Intermediate

Lesson 3 – Using Operators in Queries

Access 2016

Create an Or condition for a single field in the Criteria row using the Or operator. Typing Northeast Or Southeast Or Central into the Region field Criteria row finds all records in any one of the three regions.



Procedures

1. Open the desired query in Design view. 2. Select the desired field’s Criteria row. 3. Type the desired criterion. 4. Select the desired field’s or row. 5. Type the second criterion. 6. Press [Enter] .



Step-by-Step

Use an Or condition 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.

Click in the Sales Rep field Criteria row

2. Type the desired criterion.

Type sjs

The criterion appears in the Criteria row .

3. Select the desired field’s or row.

Click in the Region field or row

The insertion point appears in the or row .

4. Type the second criterion.

Type southeast

The second criterion appears in the or row.

Page 58

OFFICEPRO, Inc.