Removing #Error from report

[VeeFour]

I have a series of calculated fields on my report which show #Error when there is no value generated by a query. I want to change the field value to 0 if the query/sub-report returns the #Error.

Many thx in advance.

 

[JonoB]

Try the Nz function

 

[VeeFour]

Can you elaborate on this function and how to implement it please.

 

[JonoB]

Have a look in Access help...has clear documentation on Nz function.

If you errors are in fact due to null's (not sure if this is right or not), then the Nz function allows you to substitute any null's with a number of your choice.

Example : Nz([value],0) will change any null values in the [value] field to a zero.

Hope this helps.