Another Running Sum


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

Advertisements

J

Jeff Boyce

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

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
M

Marshall Barton

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?


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

Advertisements

I

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top