sum field error

  • Thread starter Thread starter JIM.H.
  • Start date Start date
J

JIM.H.

Hello,
In my report I use Sum([fieldName]) to find the total in
my report. If there is no detail data listed this returns
error. How should I say show 0.
Thanks,
Jim.
 
JIM.H. said:
In my report I use Sum([fieldName]) to find the total in
my report. If there is no detail data listed this returns
error. How should I say show 0.
Click to expand...


Use the report's HasData property to check for that
situation:

=IIf(Report.HasData, Sum([fieldName]), 0)
 
Back
Top