Null Value in reports

D

Don

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.
 
D

Don

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.
 
P

Pieter Wijnen

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

Pieter

Don said:
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.
Jerry Whittle said:
Look into the NZ and IsNull functions in Help.
Click to expand...
Click to expand...
 
Top