Go Back   Access World Forums > Microsoft Access Reference > Access FAQs

 
Closed Thread
 
Thread Tools Rate Thread Display Modes
Old 07-01-2009, 11:15 AM   #1
ajetrumpet
Banned
 
Join Date: Jun 2007
Location: Universe - Local Group - Milky Way Galaxy - Orion Arm
Posts: 5,640
Thanks: 0
Thanked 100 Times in 47 Posts
ajetrumpet has a spectacular aura about ajetrumpet has a spectacular aura about
Send a message via MSN to ajetrumpet Send a message via Yahoo to ajetrumpet
Crosstab Query Examples (Financial Analysis)

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


Last edited by ajetrumpet; 07-02-2009 at 02:02 PM.
ajetrumpet is offline  
The Following 2 Users Say Thank You to ajetrumpet For This Useful Post:
eirman (08-21-2013), hassanogaibi (06-28-2016)
Closed Thread

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Crosstab query in VBA/SQL jmeek Forms 0 04-21-2008 09:18 AM
Problem with reprot based on a Crosstab Query keving Reports 3 02-19-2007 11:24 AM
Crosstab query with criteria from form trouble adamlaing Queries 1 04-08-2005 11:01 AM
empty fields causing problems Christos Queries 2 04-27-2003 06:31 PM
How? Multiple-fields in Crosstab query Shinken Queries 2 10-07-2002 06:35 PM




All times are GMT -8. The time now is 08:25 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World