Calculate Running Sum on Report

[mcupito]

I am trying to calculate 2 sums of 2 different fields on a report.

The fields are aggregates themselves.

Current Units: Sum(([AwardTbl]![AwardUnits]-[AwardTbl]![ForfeitedUnits]-[AwardTbl]![PaidOutUnits]))

For example.

I have tried creating a text box in the footer, putting [Current Units] in the Control Source and selected Running Sum Over All and I tried Over Group. Neither summed anything, they only provided me with the value of the last record on the report.

I also tried (in the text box)

=Sum([Current Units])

which did not work, either.

Here is the SQL for the report.

SELECT AssociateTbl.AstFirstName, 
AssociateTbl.AstPrefName, 
AssociateTbl.AstLastName, 
Sum(([AwardTbl]![AwardUnits]-[AwardTbl]![ForfeitedUnits]-[AwardTbl]![PaidOutUnits])*[LastOfNetAssetValue]) AS [Current LTIR Value],
 AssociateTbl.EmployeeID, Sum(([AwardTbl]![AwardUnits]-[AwardTbl]![ForfeitedUnits]-[AwardTbl]![PaidOutUnits])) AS [Current Units]
FROM MaxNAVQry, AssociateTbl
 INNER JOIN AwardTbl ON 
AssociateTbl.EmployeeID = AwardTbl.EmployeeID
GROUP BY AssociateTbl.AstFirstName, AssociateTbl.AstPrefName, AssociateTbl.AstLastName, AssociateTbl.EmployeeID
HAVING (((Sum(([AwardTbl]![AwardUnits]-[AwardTbl]![ForfeitedUnits]-[AwardTbl]![PaidOutUnits])*[LastOfNetAssetValue]))>0) AND ((Sum(([AwardTbl]![AwardUnits]-[AwardTbl]![ForfeitedUnits]-[AwardTbl]![PaidOutUnits])))>0));

I am trying to sum both Current Units and Current LTIR Value. Any ideas?

[zmbd]

As far as I know, the method hasn't changed since ACC2003 so here's the link to that information: Calculate a running sum (cumulative total) (ACC2003)

Here it is from a different angle: Summing in reports


From the 2007 perspective... as you can see not much difference in effect; however, you can now use the layout view to create the sums. yea... not sure that's much of an improvement: Summing in reports (ACC2007)

And just one more angle as this is in the query... not sure if this runs faster in the query that is fed to the report or if the report is faster... I typically will use the query though and then feed it to the report for running totals, and then aggregate counts I'll use the report - just a habit.
How to create a running totals query in Microsoft Access (ACC2000-2010)

[mcupito]

I had to put it in the report footer, not the page footer. DOH. Thanks, z!