Dealing with Null Value's

[Robert Sykes]

I have a report that has a summary of items on several subreports. If the
values in the subreports it shows up as #error in the summary, how do I
change them to read "0" instead?

Example: =[MEMBERS - CANCELLED].Report![Can Total]

Thanks in Advance.

--
Notice of Confidentiality:
This transmission contains information that may be confidential and that may
also be privileged. Unless you are the intended recipient of the message
(or authorized to receive it for the intended recipient), you may not copy,
forward, or otherwise use it, or disclose its contents to anyone else. If
you have received this transmission in error, please notify us immediately
and delete it from your system.

 

[Marshall Barton]

I have a report that has a summary of items on several subreports. If the
values in the subreports it shows up as #error in the summary, how do I
change them to read "0" instead?

Example: =[MEMBERS - CANCELLED].Report![Can Total]

=IIf([MEMBERS - CANCELLED].Report.HasData, [MEMBERS -
CANCELLED].Report![Can Total], 0)