Another Running Sum

  • Thread starter Thread starter iamnu
  • Start date Start date
I

iamnu

My report has a ProcessDate Header/Footer and a AcctNum Header/Footer.

I currently have a control in the AcctNum Footer with the Control
Source =Sum([ProviderMayBill]), and Running Sum "Over Group".

How do I "Reset" the Running Sum to zero for each ProcessDate change?
 
What happens if you put the control in the [ProcessDate] footer instead?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
iamnu said:
My report has a ProcessDate Header/Footer and a AcctNum Header/Footer.

I currently have a control in the AcctNum Footer with the Control
Source =Sum([ProviderMayBill]), and Running Sum "Over Group".

How do I "Reset" the Running Sum to zero for each ProcessDate change?
Click to expand...


If I understand what you are trying to do, that should be
taken care of by the OverGroup setting.

How are you displaying the total in the ProcessDate footer?
 
What happens if you put the control in the [ProcessDate] footer instead?

Regards

Jeff Boyce
Microsoft Office/Access MVP


My report has a ProcessDate Header/Footer and a AcctNum Header/Footer.
Click to expand...
I currently have a control in the AcctNum Footer with the Control
Source =Sum([ProviderMayBill]), and Running Sum "Over Group".
Click to expand...
How do I "Reset" the Running Sum to zero for each ProcessDate change?
Click to expand...
Click to expand...

I put the same control in the ProcessDate Footer as suggested, but
this only gave me the Running Total for the Year. I then realized
that the ProcessDate Footer Group Properties for Group On was set to
"Year". So I created another Field/Expression ProcessDate, but this
time I set the Group On property to "Each Value", and now it works
perfectly.

Thanks for the suggestions, gentlemen...
 
Back
Top