Adding Fields from Several Subreports

[LisaB]

I have created a report which contains 5 subreports (sort of like a summary page). If a subreport has an empty recordset, I used the HasData Property to hide that subreport. I then have a calculated control adding each field across the subreports. This is where my problem comes up. If a subreport has no data, I get a #Error in the control. The control adds properly as long as there are records in each subreport. Is there a way to make the calculated control ignore a hidden subreport and add only the subreport fields that have data? I appreciate any help...I'm really stuck. Thanks.

 

[Axis]

You can use the Nz function to return a zero if a field returns null. Look in Help for more info.