Access 2016 Intermediate

Access 2016

Lesson 3 – Using Operators in Queries

Create an And condition by adding multiple criteria to a single field by using the And operator to find records that fall within a range. For example, to find customers whose contract dates fall between 9/1/2012 and 9/30/2011, type both criteria on a single line in the appropriate field’s Criteria row ( >=9/1/02 And <=9/30/02 in the Contract Date field). An And condition is assumed when you enter conditions in the same Criteria row of two or more different fields; in this case, the And operator is unnecessary. For example, to find customers in PA with sales to date of over $10,000, you would type each criterion in the same Criteria row of the appropriate fields ( =PA in the first State/Province field Criteria row and >10000 in the Sales to Date field first Criteria row).

Using AND in a query

NOTE Criteria entered in the same design grid row create an And condition, and criteria entered in different rows create an Or condition. Use the Expression Builder by selecting the Criteria row and, on the Ribbon in the Design tab Query Setup group, click the Builder button .

OFFICEPRO, Inc.

Page 55