Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Balance Due Problem

Status
Not open for further replies.

cheyenne2002

Instructor
Jul 26, 2005
229
US
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top