Balance Due Problem

[cheyenne2002]

I'm trying to create an invoice where I can add up the total donations. No problem there, so far, I think.

I have the following the the subinvoice footer.
=Sum([AmountOfDonation])

My problem is when I try to show a balance due. What I need to do is take the answer from the above formula and subtract [AmountReceived] from it. But I can't seem to use the formula in the second formula. Maybe it can't be done. I'm not sure. Might just be over my head.

Any suggestions. Keep in mind, I'm not too good at SQL.

LOL, if that wasn't apparant by my question. DUH
Sharon

 

[cheyenne2002]

I think I solved the problem, but now I would like to how this info in the subreport page footer.

But nothing seems to show up in there. I even did a test and just stuck a label that said "Hello". This did not show up.

Any idea on what I am missing.

Sharon