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.

Filter with mathematical comparisons

Filter with mathematical comparisons

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

Start my 1-month free trial

Filter with mathematical comparisons

“

- [Narrator] When it comes to filtering data, there's one additional class of operators that's specifically used with numerical data. They're called comparison operators, and they're useful for all those situations where you want records returned that are above or below a specified numerical value. Let's put those to use and take a look at what our guests are spending per night. And to do that, we'll start by creating a new query in design view. Now, the data I want to look at can be found in the guest table, combined with the room assignments table, and finally we can get the room rates from the room rates table. Let's go ahead and double click on that, and close the show table window. From these tables, I want to pull out the first and last name of my guests, the check in date, and the room ID that they checked into, and finally the rate they paid for that particular room. If I take a look at the data sheet right now before we add in any criteria, I can see that I have 2249 records…

Contents