From the course: Access 2021: Queries

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Process a column of values with domain functions

Process a column of values with domain functions

From the course: Access 2021: Queries

Start my 1-month free trial Buy for my team

Process a column of values with domain functions

“

- [Instructor] The domain aggregate functions are a useful set of functions that'll help you parse out information from the database and calculate values over the entire column or what's referred to as the domain of a data table or queries record set. We can explore this concept by taking a look at the customer loyalty query that we created earlier in the course. You'll remember that this query is returning the customer name as well as how many products each customer has ordered. There's also a column that used the switch function to determine which loyalty program they belong to. Now, I'd like to expand this and see how much each customer is above or below, the average number of products purchased. It would also be nice to be able to see how many products each person would need to buy in order to move to the top position in the rankings. We can accomplish both of these tasks using domain functions. Let's take this…

Contents