Running Balance in a Text Box on a Report

[CoolFactor]

I a report grouped by month and in a text box,
I have the following:
=Sum(IIf([Contributions/Disbursements]>0,([Contributions/Disbursements]*-1),[Deposits/Receipts]))
in a text box and have also set the Running Sum Option to overall in the Data Tab. Within this expression I would like to see if I could dim the total per month back one month if possible.

Let me know if you need a little more of an explanation.

 

[dhookom]

Where is the text box?
What do you mean by "dim the total per month back one month"?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[CoolFactor]

The text box is on the report in the Date Header section. What I mean by "dim the total per month back one month," is that I have a running balance like so: =Sum(IIf([Contributions/Disbursements]>0,([Contributions/Disbursements]*-1),[Deposits/Receipts]))
in a text box and have also set the Running Sum Option to overall in the Data Tab. This gives me the right amount at the end of the month. For example lets just say that the ending balance for October is $30,000. What I want to know is instead of showing me the ending balance for October, I would like to see the ending balance for September whatever that may be.

This works just fine:
=Sum(IIf([Contributions/Disbursements]>0,([Contributions/Disbursements]*-1),[Deposits/Receipts]))
in a text box and have also set the Running Sum Option to overall in the Data Tab

Now I just want to add that element that will scale it back a month.

 

[dhookom]

Try use the previous month's group footer.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[CoolFactor]

I actually have to place this text box in the date header section

 

[dhookom]

Do you have a date footer section? If not, create one the exact same height as the date header section. Place your control in the Date footer and then add code in the On Format property of the Date Footer section to:

Me.MoveLayout = False

This will overlay the date footer on top of the next date header section.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[CoolFactor]

That doesn't seem to work either. I appreciate all your help.

 

[dhookom]

What do you mean by "doesn't seem to work"?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[CoolFactor]

What I mean is that it is not giving me the right amount in the text box.