Null Value in reports

[Guest]

I have a report that has calculations. When a null value is in the
calculation, the report displays a '#error' message. How do I get rid of the
error and return a blank?

Thanks.

 

[Guest]

Look into the NZ and IsNull functions in Help.

 

[Guest]

I have found that on Help and do not understand. Below is my calculation
that I have on control source on my form. If 'A' is null I am getting the
#error message. Do you know how I use Isnull or NZ function to return a
blank on my form/report.

=([A]+)

Thanks.

 

[Pieter Wijnen]

=(Nz(A,0) + Nz(B,0))

Pieter

I have found that on Help and do not understand. Below is my calculation
that I have on control source on my form. If 'A' is null I am getting the
#error message. Do you know how I use Isnull or NZ function to return a
blank on my form/report.

=([A]+)

Thanks.

Look into the NZ and IsNull functions in Help.