Null value problem

  • Thread starter Thread starter LJG
  • Start date Start date
L

LJG

Hey Guys,

I am completing a summary on a report and getting values form other
subreports. I have tried:

=Nz(rptEcom.Report!txtecom_total)

But keep getting #error message in the field, can anyone tell me the correct
way to structure this please.

TIA

Les
 
To the NZ function add a value you want to replace the null
=Nz(rptEcom.Report!txtecom_total,0)
 
Did you check the values in your sub report, you might need to put the NZ
function in the detail also, if one of the records in the details of the sub
report return an error then you'll get it in the total also

Are you displaying a total on a calculated field in a sub report?
Check the recordsource of the report and see if one of the values is error.
 
Nz() won't ever work if the subreport contains no records.
=IIf(rptEcom.Report.HasData,rptEcom.Report!txtecom_total,0)
 
Many thanks again Duane, that has solved it

Les

Duane Hookom said:
Nz() won't ever work if the subreport contains no records.
=IIf(rptEcom.Report.HasData,rptEcom.Report!txtecom_total,0)
Click to expand...
 
Back
Top