Adding calculated column on a report from a Crosstab query 1

[jckokko]

I have a crosstab query that results to following report:
DepName1 DepName2 ..
ExpCat1 $10 $5
ExpCat2 $500 $250 ..
: : :

However, I want to add one more column "Balance" to result in the following report:
DepName1 DepName2 .. Balance
ExpCat1 $10 $5 .. $15
ExpCat2 $500 $250 .. $750
: : :

Help.

 

[dhookom]

Usually when you ask a query question, you should post your sql view. I think you can just create another Row Heading that has the same expression as your "Value". Set the Total: to Sum.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[jckokko]

Duane,
you can tell that I am a newbie to Access.
I did create a column as "TotalSum: currentAmnt" and set the "Total: " to "Sum" as another "Row Heading". It simply worked.
It's not obvious to think of a "Row Heading" as a column.

Thanks Duane.

 

[dhookom]

This is one of the more confusing aspects of crosstabs. You have to think of Rows as the horizontal "record". Its Row Heading is on the left of the row.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.