Crosstab Query Examples (Financial Analysis) (1 Viewer)

Status
Not open for further replies.

ajetrumpet

Banned
Local time
Today, 14:26
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
 

Attachments

  • Financial Analysis Crosstab Queries (2000).zip
    28.1 KB · Views: 1,130
  • Financial Analysis Crosstab Queries (2003).zip
    28.4 KB · Views: 1,308
Last edited:
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom