creating a "Balance Due" for a Payment History Report?

[Guest]

Good Day,

I have a report that show payment history for customer invoices. on this
report I have the following field pulled from tblpaymenthistory:

paymentnumber
paymentdate
paymentamount
invoicetotal

For each payment that is made, I would like a field to show a running
"Balance Due"

I have looked the group, but cannot find what I am looking for.

Can anyone pass any suggestions?

Thanks,

Brook

 

[Marshall Barton]

I have a report that show payment history for customer invoices. on this
report I have the following field pulled from tblpaymenthistory:

paymentnumber
paymentdate
paymentamount
invoicetotal

For each payment that is made, I would like a field to show a running
"Balance Due"

Presumably, InvoiceTotal is the amount due. If so, you can
add a (invisible?) text box named txtRunPaid bound to the
PaymentAmount field and set its RunningSum property to Over
Group.

The running amount due text box can the use the expression:

=InvoiceTotal - txtRunPaid

 

[Guest]

Marshall,

Thank you very much... that worked perfectly!

Brook