Trouble totaling.

[Guest]

I have the following Data and subtotals working just fine...

CURRENT 1 2
PREVIOUS -1 -3 -
VARIANCE 0 -1
CURRENT 5 6
PREVIOUS -6 -4 -
VARIANCE -1 2

WHAT I NEED IS A TOTAL AT THE VERY BOTTOM/LAST PAGE OF THE REPORT THAT IS AS FOLLOWS...

TOTAL CURRENT 6 8 1
TOTAL PREVIOUS -2 -7 -
TOTAL VARIANCE 4 1

I can't seem to make it work. Any help would be appreciated.

 

[Marshall Barton]

I have the following Data and subtotals working just fine....

CURRENT 1 2 3
PREVIOUS -1 -3 -2
VARIANCE 0 -1 1
CURRENT 5 6 8
PREVIOUS -6 -4 -3
VARIANCE -1 2 5

WHAT I NEED IS A TOTAL AT THE VERY BOTTOM/LAST PAGE OF THE REPORT THAT IS AS FOLLOWS....

TOTAL CURRENT 6 8 11
TOTAL PREVIOUS -2 -7 -5
TOTAL VARIANCE 4 1 6

Have you tried using the Sum function in the Report footer?
That won't get them to appear at the "very bottom", but it
should at least get the totals on the last page. Once
you're getting the totals to work correctly, you can use
http://support.microsoft.com/default.aspx?scid=kb;en-us;119655&Product=acc
to position them on the page (probably method 1).