Hello, I have been getting suggestions for the past few days about how to fix some mistakes in my report. I now, have 2 (Invoice and Payment) subreports in my major report. I am now trying to calculate fields from the 2 subreports to show in the project footer of my major report. I think that I have my calculated fields up & running in my report. The only problem is that if there is no payment or no invoice, the calculated amount shows an error for some projects. How can I fix this problem?

Hi,

I,m not sure how you have set your design structure but try using IIF Is Null function i.e.

IIF(IsNUll([Invoice_No]),"0",[Invoice_No])

See if this helps!

Majid!

Thanks for the sugestion, but I am still getting an error. I have it in there as: IIF(IsNull([Copy of Payments].[Report]![Text24]), "0",[Copy of Payments].[Report]![Text24])

Is there anything wrong with the way I have it? Let me know if you have any other suggestions.

Billie

Please continue with the same thread it's not neccessary to start another with the same question.