#Error in Total Field

[Brent Taylor via AccessMonster.com]

I am getting an #Error in my Footer total for three sub reports in this
section when data is null in one or more of my three fields. I have it set
up as:

=ZZZ1.Report!T1TotalP+ZZZ2.Report!T2TotalP+ZZZ3.Report!T3TotalP

I have tried =IIf(Report.HasData=True,Report!Amt,0)in the "On No Data" and
"On Error" in addition to every possible approach that I can think of.
Nothing has worked.

Any ideas??

Thank you,

Brent

 

[jl5000]

Try:

=nz(ZZZ1.Report!T1TotalP)+nz(ZZZ2.Report!T2TotalP)+nz(ZZZ3.Report!T3TotalP)

nz converts a null value to 0 using the syntax I'm suggesting,

 

[Duane Hookom]

Don't add anything to the On No Data or On Error event properties. Use a
control source like:
=IIf(ZZZ1.Report.HasData,ZZZ1.Report!T1TotalP,0) + IIf(ZZZ2.Report.HasData,
ZZZ2.Report!T2TotalP,0)+IIf(ZZZ3.Report.HasData, ZZZ3.Report!T3TotalP,0)

 

[Brent Taylor via AccessMonster.com]

Thank you very much! I tried everything that I could think of and nothing
worked. This resolved the problem and allowed me to get up and running.

THANK YOU!