HOW TO ELIMIATE #ERROR IN THE REPORT 1

[pelagic]

Hi all,
I have tried Nz([FielName], 0)
I also tried IIF(IsNull([FielName]), 0, [FieldName])
but the report still display #ERROR.

Note: the report is getting data from the query.
Is there away to set the default value on the report field name? or any way I can get around it

Thanks,

 

[cghoga]

=IIf([FieldName] Is Null,0,[FieldName])

 

[dhookom]

Does your report have any records when you see #ERROR? Or, do you see #ERROR all the time?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[pelagic]

Hi dhookom,
The report displays #ERROR when it has no records.
Can I display zero when it has no record?

regards,

 

[dhookom]

This last bit of information should have been mentioned in the first posting to this thread. No manipulation of Nz() or IsNull() can resolve this issue.

You can use an expression like:
=IIf([HasData],...previous expression...,0)

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[glalsop]

Access reports also have a NoData event that fires when the report's record source doesn't have any records. You can display a message box informing the user that there are currently no records, etc., and then cancel the report.

-Gary