Replacing #Error with zero (0) in a calculated field

[cakoli]

I am trying to use values from a calculated field of a subreport in another calculated field of a report, containing that subreport. The problem is that for records in the report, which do not have any value in the subreport, I get #Error in my calculated field. I am trying to replace that #Error with 0. How can I do that? I want to show on my report only numeric values.

 

[jesseb]

use the nZ() function. There is a pretty good example on the Help in Access.

 

[cakoli]

ThankYou for the suggestion, but I caouldn't make it work for me. I found anouther solution using the IsNull() and some tricks. It was like moving your right hand round the neck to catch your left ear, but it works for me. If anybody has any better solution it will be helpfull.

 

[Rich]

Look up the HasData method.
HTH