Access 2016 Intermediate

Access 2016

Lesson 3 – Using Operators in Queries

Steps

Practice Data

5. Press [Enter] .

Press [Enter]

The Or condition is added to the design grid.

Run the query. Notice that records matching either Or condition appear in the recordset.

Return to Design view and delete all criteria.

U SING THE B ETWEEN A ND O PERATOR



Discussion

Use the Between And operator to find data that includes or falls between two stated values. To find all records of customers with credit limits between 1000 and 2000, for example, you would enter Between 1000 And 2000 in the Credit Limit field Criteria row.

The Between And operator can be used in text, numeric, or date fields.

Using BETWEEN AND in a criteria

OFFICEPRO, Inc.

Page 59