Nz Help

[Joe C]

Hello,

I have a main report that needs to add a field from a sub report. I keep
getting #error.

This is what I have on the Main Report to test for errors:

=(NZ([Blank Weekly subreport].Report!SUMOTRA))

This is what I have on the Sub report, which is Blank Weekly Subreport

=Sum(Nz([OT rate]))
I have tried every possible combination I can think of. Please help.

JC
Papi

 

[Marshall Barton]

I have a main report that needs to add a field from a sub report. I keep
getting #error.

This is what I have on the Main Report to test for errors:

=(NZ([Blank Weekly subreport].Report!SUMOTRA))

This is what I have on the Sub report, which is Blank Weekly Subreport

=Sum(Nz([OT rate]))

That typically happens because the subreport has no records
that match the linking field in the main report. The way to
deal with this situation is to use:

=IIf([Blank Weekly subreport].Report.HasData, [Blank Weekly
subreport].Report!SUMOTRA, 0)

The only other reason I am aware of is when the subreport
total has #Error as well.