Subreports

[Al-Bito]

Hello- Access 2002 user, have a subreport which provides data when available,
however, if no data is available in the subreport, the header does not show
in the main report, nor the calculation that is being done in the subreport.

The calculation in the sub is used in the main report but #Error is shown
when the subreport pulls no info. How can I get rid of the #Error or create
an iif statement so I can work around the #Error?

Any help would be greatly appreicated.

Thanks,

Al

 

[Al-Bito]

I figured this out per a post from Marshall Barton in 2007. Thanks.