Another Running Sum

[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?

 

[Jeff Boyce]

What happens if you put the control in the [ProcessDate] footer instead?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Marshall Barton]

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?

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?

 

[iamnu]

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.

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?

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...