ajetrumpet
Banned
- Local time
- Today, 04:35
- Joined
- Jun 22, 2007
- Messages
- 5,638
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
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
Attachments
Last edited: