How to make amounts subtract

[Micron]

see if this helps
https://www.accessforums.net/showthread.php?t=70301

[simmiepam]

OK. I think I've attached it correctly.

if you'll open the REPORT...GENERAL FUND...you'll see a field for:

BALANCE BEFORE MONTHLY EXPENDITURES: $127,120.03

In the details, the first entry is for taxes....$117.00

I want the balance field for that row to be $127,003.03 (which is $127,120.03 - $117.00)

Then the newt row for CHECK order is $117.00.

I want the balance for that field for that row to be $126,886.03 (which is $127,003.03 - $117).

And so on.....

Can you do it?
Pam

[Micron]

Wasn't real hard once I could see your report design. Would you like me to explain how it works, or would you enjoy the challenge of figuring it out and posting the answer? I copied your report then altered the original. That way, you can see both designs while you have the same db open.

countB.zip

[simmiepam]

I created it in access 2003 and cannot open your database. Can you convert to a .mdb?

[Micron]

I didn't expect that from just modifying your report. Saved as a 2003 version, let me know if there's a problem.

Church Statement.zip

[simmiepam]

Yep, you're going to have to explain it to me how you did that. What is "txtpayment" and and where did that come from???
You're a genius!

[simmiepam]

Ahh...I see a field that equals to the amount that is named txtpayment.

I had tried something like this where I had the balance field be a summation of the expenditure - amount....but that made EACH balance the same.

This is amazing!

[Micron]

For the benefit of others, what you needed was an unbound invisible text box that was set to be the payment amount and was set to running sum over group. For each record, that will increase according to the amount of the payment. Beside that is another text box for the balance, placed under your balance label (for which you had no control on the report). That one is set to equal the starting amount text box minus the payment amount. Since the starting balance is fixed (it is not part of the group of records) and the accumulating running sum gets larger for each record, the balance gets smaller by the payment amount.

Glad to have been of some help.

[simmiepam]

Your brain is amazing. I love you....thank you again.

[Micron]

_____ _____