What is a Microsoft Access Crosstab Query? Here’s the simple answer by asking a different question. Do you know what an Excel Pivot Table is? If you do, then you have just answered the first question!
In fact, Microsoft Access Crosstab queries are quite basic and limited when comparing to the newer and richer reporting outputs of a Pivot Table but it’s still in use and effective.
Take a look at this video tutorial (no more than 5 minutes) called
Microsoft Access 2003 Tutorial Crosstab Queries
The trick is to base this type of Microsoft Access query on another query which would typically be made up from related tables.
To learn more about queries of all types, take a look at one of my eBook on More Microsoft Access Queries. There are other eBooks too, Microsoft Access eBooks.
Tags: access crosstab query, access database queries, crosstab queries, how to create an access crosstab query, Microsoft Access 2003, ms access 2003 crosstab queries
The best way to undertand and then expand a Crosstab query is to first use the wizard tool and then modify it in the design view.
This applies to all versions of Microsoft Access.