Trouble totaling.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
SHIPP said:
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
Click to expand...


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).
 
Back
Top