Calculation On A Report

[stanger1]

I want my report to calculate the sum of a field called credit_3. The field calculates fine until there are blank records on the report. When blank records show up, the calculated field shows #error. I have tried to use the nz function EX: (=Sum(nzl([credit_3])), but still get the same error message. Any help on this error would be greatly appreciated.

 

[KenHigg]

Use the nz() in the underlying query or set the deault value for the fld to 0.

???
kh

 

[stanger1]

Thanks for the reply! There is another problem with the calculated field when there are no records on the report. When the report is displayed and no records are present, the calculated fields show #error. Is there a way to fix that to?

 

[mcadle]

In the control source of the field put this:

=iif(isnull[field name],"No records","[field name])

As for the null records, I would set the default prop to 0.

 

[stanger1]

Perfect! Thank you for your help!

Greg