Access 2016 Intermediate

Lesson 3 – Using Operators in Queries

Access 2016

Steps

Practice Data

6. To enter a value, select existing text or position the insertion point as needed in the Expression field. The text in the Expression field is selected.

Double-click the first in the Expression field

7. Type the desired value.

Type 6/1/01

The text appears in the Expression field.

8. Complete the expression.

Replace the second element with 6/30/03 .

The expression appears in the Expression field.

9. Select OK .

Click

The Expression Builder dialog field closes, and the expression appears in the Criteria row.

Run the query. Notice that only records matching the criteria appear in the recordset.

Return to Design view and delete the criteria.

U SING A W ILDCARD C HARACTER



Discussion

Use a wildcard in a query in place of one or several characters. Wildcard characters are helpful when you want to find criteria with a pattern (such as all last names beginning with M), or if you are not sure exactly how values you want to find appear (such as the correct spelling—Kline or Klein).

The two most common wildcards are listed in the following table:

Wildcard

Used for

Example

?

Any single letter or number

Sm?th finds Smith and Smyth, whereas ?andy finds Sandy, Randy, and so on.

Page 64

OFFICEPRO, Inc.