From the course: Access 2019 Essential Training

Unlock the full course today

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

Specifying criteria with wildcards

Specifying criteria with wildcards

From the course: Access 2019 Essential Training

Start my 1-month free trial

Specifying criteria with wildcards

“

- [Instructor] Adding wildcard characters to your query criteria is perfect for those times when you want to filter your data based off of a common pattern rather than an exact text match. Let's take a look at our guests here, and create a new query based off of them. I'll come up here to the create tab, and then click on query design. We're gonna pull in just the guests table, double-click on it to enclose the show table window. And the only data I wanna look at is the first name and the last name of our guests. Now previously, we saw that we can add in a criteria here for an exact text match. If I wanted to find all of the guests with the last name of Miller, I would just type in Miller here. When I press enter, Access wraps that in double quotation marks because we're exactly matching the text, Miller. I'll go ahead and view the data sheet, and we'll see that we have a total of three guests that have the last name Miller. But what if we wanted to see all the guests that have the…

Contents