|
||||||
Crosstab By Richard Rost 2 years ago 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
Recommended Courses
Keywordsaccess 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
|
||||||||||||||||
| |||
Keywords: FastTips Access 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, Crosstab Query Wizard PermaLink Crosstab Queries in Microsoft Access |