List Customers with Above Average Orders in Access

In this Microsoft Access tutorial, I will show you how to use subqueries to list customers with above-average orders. You'll learn to calculate average order values and apply these to filter out larger orders efficiently. This session offers expert-level insights, ideal for those seeking to enhance their querying skills without delving into programming.

Riley from Madison, Wisconsin (a Gold Member) asks: How can I generate a list of my customers who have placed above-average orders? For example, if the average order size in my system is $100, I want to see which customers have placed orders larger than that. What's the best way to do this in Microsoft Access?

Members

There is no extended cut, but here is the file download:

•  File Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Query Criteria
• DAvg
• SQL with Access
• Aggregate Query

Links

• Invoicing

Recommended Courses

• Subqueries in Access Expert 32

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, subquery in Access, above-average orders query, Access subquery tutorial, querying customers with high orders, Access aggregate queries, Access Order Summary, Access SQL functions, Access query criteria, D average function, SQL average function, Access performance optimization, TechHelp Access tutorial