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.

Incorporating AND and OR statements

Incorporating AND and OR statements

From the course: Access 2019 Essential Training

Start my 1-month free trial

Incorporating AND and OR statements

“

- [Instructor] Adding multiple query criteria to filter your records can be accomplished in a couple of different ways. Let's create another query that it further explores our guest data. We'll go into the Create tab and choose Query Design. This time I'm going to pull data out of the Guest table, the Room Assignments table, and the Rooms table. Going to close the Show Table window. From there, I want to see the first and last name of our guest, the check-in dates, and the Room ID that they were assigned to. And finally, from the Rooms Table, I want to see the room name as well as the type of bed that that room includes. Now if we add multiple criteria on the same criteria line, Access is going to treat them as a logical and statement. Underneath our room name, we're going to type in a criteria of Victoria, this is one of our rooms that we have here at the Landon hotel. If I run this query we'll see that we have lots of Victoria rooms, and there is a bed configuration that includes a…

Contents