Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Have a running total show in group header, but calculate in group foot

Status
Not open for further replies.

qoqoqoqo

MIS
Jan 25, 2002
8
CA
I have a formula for calculating records in a group in a group footer. This is fine
The only thing I am having issues with is moving the number that is evaluated in the group footer to the group header once the running total has totalled and reset
Ie. Calculate the running total count and then take the number and plug it into a column in a group header
Ive tried using variables to hold the value coming out of the running total and tried evaluateafter in the group header but to no avail
Any suggestions on the logical course of events is welcome
Thanks!
 
You did not post your solution. I have a similar problem and I am in need of a solution.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top