From the course: Access 2019: Queries

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Use wildcards in criteria

Use wildcards in criteria

From the course: Access 2019: Queries

Start my 1-month free trial

Use wildcards in criteria

“

- [Instructor] When it comes to matching text values, sometimes you won't have an exact text string that you want to find. Often, you'll simply have a pattern or want to search the database by a common initial letter, prefix or suffix. In order to perform these types of fuzzy text matching, you'll turn to something called a wildcard. To take a look, we'll go to the Create tab and start a new query in design view. I'll add an e-customers table and close the Show Table window. And this time I'll just add the first name and the last name columns down below. Now if I wanted to find all the customers that have a last name that starts with G-I-L-L, and then anything after that, what I can do is come down here to the Criteria section, and I'll type in G-I-L-L and then the wildcard character, asterisk. Asterisk means any character and any number of characters. When I press Enter, Access fills in the required operator here, like, and then it wraps in G-I-L-L asterisk in double quotation marks.…

Contents