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.

Filtering with mathematical comparisons

Filtering with mathematical comparisons

From the course: Access 2019 Essential Training

Start my 1-month free trial

Filtering with mathematical comparisons

“

- [Narrator] When it comes to filtering your data, there's one additional class of operators, that is specifically used with numerical values. They're called comparison operators and are useful for all those situations when 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 with a new query. Once again we'll come up to the Query tab, and start with a query design window. This query is going to involve the guests table, the room assignments table, and, finally, the room rates table, this is where we're going to get some rate information. We're going to close the show table window, and we're going to choose the guest table, we're going to have the first name, so double-click there, last name, as well as check-in date, from the room assignments table, the room ID that they were checked in to, and, finally, we can get the room rates table and we'll find the rate value. As a…

Contents