F
Fay Yocum
What I want to do is print an invoice that shows current charges for the
month and any past due payments. I probably set this up wrong but it ends up
being a combination of four reports.
subsubrptPastDueStatements shows total for invoices that are outstanding
minus any partial payment
subsubrptInvoiceMemberFees shows line items for current invoice
Both of those are placed on a subrptInvoiceMember that has the member's name
and address and the grand total comes from the two above reports. My current
problem is that if there is outstanding payments I get an #Error message. I
have tried to use the NZ in IIF(IsNull) and have been unable to create the
correct formula. I would appreciate any and all help. I get the error
message with the following formula.
=subrptInvoiceMemberFees.Report!sumFees+subsubsubrptPastDueStatement.Report!
sumRemaining
Fay
month and any past due payments. I probably set this up wrong but it ends up
being a combination of four reports.
subsubrptPastDueStatements shows total for invoices that are outstanding
minus any partial payment
subsubrptInvoiceMemberFees shows line items for current invoice
Both of those are placed on a subrptInvoiceMember that has the member's name
and address and the grand total comes from the two above reports. My current
problem is that if there is outstanding payments I get an #Error message. I
have tried to use the NZ in IIF(IsNull) and have been unable to create the
correct formula. I would appreciate any and all help. I get the error
message with the following formula.
=subrptInvoiceMemberFees.Report!sumFees+subsubsubrptPastDueStatement.Report!
sumRemaining
Fay