Nz Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Joe said:
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]))
Click to expand...


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.
 
Back
Top