Summing Values in a report

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?

re: Summing Values in a report

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.

1. In the 1st Dialog, select the Table or Query for the Crosstab.
2. In the 2nd Dialog, select your Row Heading(s).
3. In the 3rd Dialog, select your Column Heading(s).
4. 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.
5. Save the Query.
6. Create a Report based on this newly created Crosstab Query, and include the Row Summation Column within it.
7. Good Luck, and let us know how you make out.

re: Summing Values in a report

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.