cheyenne2002
Instructor
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 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