Attached are some examples of how to use crosstab queries. All of the queries in the attachment are related to financial analysis reporting, but the general idea is there. I created these examples to familiarize myself more with the TRANSFORM and PIVOT statements. Personally, I think this crosstab query idea is the most difficult thing to get your head around with this program. I hope these examples help educate the community on this type of querying!

Some of the queries you will find in the example:

*Profit Analysis by Single Input Criteria Field
*Sales Numbers by Single Input Criteria Field
*Profit Analysis by Multiple Input Criteria Fields
*Sales Numbers by Multiple Input Criteria Fields
*Quarterly Analysis of Revenue by Calendar Year
*Average Monthly Sales Trend Analysis

EDIT
Added New Trend Analysis Queries