Sum of different Subreports

[TKinzer]

I have a main report with 3 subreports included. I want to total one field in all three reports to give a Grand Total of the Values. The problem is, that not all three subreports will always have a value in this filed due to no matching data from the table. How can I add these fields together?Or, make my subreport report a 0 back when there is no matching data from the table in order that Access can add the value of 0 without giving me an error?

 

[Pat Hartman]

Try the Nz() function.
Nz(YourField,0) will return a zero if YourField is null, otherwise it will return the value of YourField.

 

[TKinzer]

I tried it as "Nz(SumOfXtns,0)" within my subreport and "=Nz([Reports]![FM Analysis A Query subreport]![Text18],0)+Nz([Reports]![FM Analysis B Query subreport]![Text14],0)+Nz([Reports]![FM Analysis C Query subreport]![Text14],0)" within the actual report. Neither one seemed to work.