I've tried a couple things, but everything is resulting in #Error.
I have a subreport in a report containing payments.
Right now I have:
Name: totalPayments
Source: =srptPayments.Report!txtTotalPayments
Name: txtProjectBalance
Source: =([txtProjectSubTotal]) - IIf([TotalPayments]Is Null,0,[TotalPayments])
It doesn't seem to be detecting that it's null... or am I approaching this all wrong?
Trevor
I have a subreport in a report containing payments.
Right now I have:
Name: totalPayments
Source: =srptPayments.Report!txtTotalPayments
Name: txtProjectBalance
Source: =([txtProjectSubTotal]) - IIf([TotalPayments]Is Null,0,[TotalPayments])
It doesn't seem to be detecting that it's null... or am I approaching this all wrong?
Trevor