#Error in Total Field

  • Thread starter Thread starter Brent Taylor via AccessMonster.com
  • Start date Start date
B

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
 
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,
 
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)
 
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!
 
Back
Top