Crosstab Query/Report

[greatsky]

Hello-

Is there any way to combine the results of multiple crosstab queries
into one report? One post I read suggested temp tables and union
queries. Some SQL examples would be great.

Thanks.

Example of what I need:

Oct-06 Nov-06 Dec-06
Principal 800 780 760
Interest 100 200 300
Taxes 200 200 200

 

[Duane Hookom]

That looks like a single value crosstab with a row heading, month as column
heading, and some value as the value. If I am wrong, you should provide your
table structure and sample data.

 

[greatsky]

Thanks.

I didn't think you could have 3 values in the crosstab. Each of the
row descriptions are fields in the table...I can post structure if I
need to.

 

[Duane Hookom]

The structure was kinda what I was hoping to see in order to provide sound
advice. You could probably create a union query to normalize your data so
that each "row descriptions" would be a value in a recordset rather than a
field.

 

[greatsky]

How should I show the table structure?

The structure was kinda what I was hoping to see in order to provide sound
advice. You could probably create a union query to normalize your data so
that each "row descriptions" would be a value in a recordset rather than a
field.

 

[greatsky]

Thank you.

How would I construct the UNION query?

 

[greatsky]

Duane-

Table Structure:

FieldName Datatype Description
AGC Text Group Code
Entity Text Group
Date Date Format 10/31/2006 Monthly
Month Number Month Number e.g. 1...180
BegBal Number Beginning Balance
Am Number Monthly Amortization
CumAm Number Cumulative Amortization
EndBal Number Ending Balance

Report should look like:

10/31/2006 11/30/2006 12/31/2006
AGC 1 BegBal
Am
CumAm
EndBal


AGC 2 BegBal
Am
CumAm
EndBal

Thanks so much.

Bruce