From the course: Access 2019: Queries

Unlock the full course today

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

Return records above or below average

Return records above or below average

From the course: Access 2019: Queries

Start my 1-month free trial

Return records above or below average

“

- [Instructor] Using what we've seen about the SQL language, we can use it to help create dynamic query criteria based on summary values from the database. For example, if we wanted to find orders that have a total value above average, in order to do this, we first need to determine what the current average order value is. To do that, I'll go to the Create tab and we'll start a new Query in Design View. I'll add in the Orders Table and the Products Table. In order to find the value of each of our orders, what I need to do is multiply the quantity of the product ordered times the original product price. I'll come down here to the first empty Field and I'll right-click and go into my Zoom window. Then, I simply need to type in a reference to the Quantity Field in square brackets, and multiply that by the Price Field. Because there's only a single Quantity Field and a single Price Field across both of these two tables, I don't actually need to specify which table these are coming from…

Contents