From the course: Access Essential Training (Office 365/Microsoft)

Unlock the full course today

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

Specify criteria with wildcards

Specify criteria with wildcards

From the course: Access Essential Training (Office 365/Microsoft)

Start my 1-month free trial

Specify criteria with wildcards

“

- [Instructor] Adding wild card characters to a queries 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 that by creating a new query in design view, and we're gonna pull out information from the guest table. So, just double click here to add that in. Let's go ahead and close the show table window, and for this example the only fields that I wanna pull out are the first name and the last name. So double click on each of those. Add those into the grid below. Now if I just run this query right now and take a look at this data sheet, we'll see that we have a total of 201 records, and these are just the names being pulled straight out of the guest table. So let's assume that we want to break this list up by last name. We seen how we can simply add the last names that we want down here in the criteria row. For instance, I'll go down here under the last name column and type in Miller…

Contents