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

Unlock the full course today

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

Incorporate AND and OR statements

Incorporate AND and OR statements

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

Start my 1-month free trial

Incorporate 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 a query that explores our Guest data and uses multiple filtering criteria. Once again, we'll start the process by going to the Create tab and then clicking on Query Design. For this particular query, I wanna take a look at some information from our guests. So go ahead and double click on that table here to add it into our Query Design. I also wanna see what rooms they were assigned to when they checked in to the hotel so we'll pull in the Room Assignments table and finally, I wanna get some details about the room that they checked into and for that, I'm gonna go to the Rooms table. Let's go ahead and double click on that. Go ahead and close the Show table window and we'll see all three of those tables have been added in here to our Query Design. Now, from these, I wanna pull out some specific fields. From the Guest table, I would like to see the first…

Contents