Crosstab Query: Summarize Data from Two Fields

A crosstab query is a special kind of query that performs an aggregate function (sum, average, count, max, min, etc.) on two separate fields. So, for example, you can get the sum (aggregate) of sales by state (field 1) by month (field 2); or you could calculate the count of sales reps (aggregate) for each territory (field 1) for each product line (field 2). The possibilities are endless, and this is a great way for you to see trends in your data.

Pre-Requisites

• Calculated Fields: https://599cd.com/Calculated
• Format: https://599cd.com/Format
• Aggregate Query: https://599cd.com/Aggregate
• Relationships: https://599cd.com/Relationships

Recommended Courses

• Access Expert 17: https://599cd.com/ACX17
• Access Expert 18: https://599cd.com/ACX18

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 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

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, crosstab queries, crosstab query, like pivottables in excel, pivot tables, Make summary data easier to read by using a crosstab query, What is crosstab query, How do I create a crosstab query, How to Create a CrossTab Query, How to use the Crosstab Query Wizard, data analysis, trends, by month, row heading, column heading