I have a report which I am pulling from a crosstab query and want to calculate the values at the end of each row. This report has 5 columns named col1, col2... col5. Col6 is where the total goes. Can I solicit a little help from the No1 programming forum on the net?
-
-
In my humble opinion, there is only 1 way to accomplish this task without involving another layer of much greater complexity and that is to use the Crosstab Query Wizard to reconstruct the Crosstab Query.- In the 1st Dialog, select the Table or Query for the Crosstab.
- In the 2nd Dialog, select your Row Heading(s).
- In the 3rd Dialog, select your Column Heading(s).
- Ini the 4th Dialog, you will choose the type of Calculation to be performed at each Row/Column Intersection. In this Dialog, you will also see an Option to Include Row Sums within the Crosstab Query - select this.
- Save the Query.
- Create a Report based on this newly created Crosstab Query, and include the Row Summation Column within it.
- Good Luck, and let us know how you make out.
-
This is just what I needed. No extra coding needed, thank God. I have gained so much from this forum that it feels like college again... How fun-filled were those days. Thanks guys for having the best forum online.Comment
Comment