Subreports and sum 1

[mollow]

Hi,

I am writing a report that uses several subreports. I want to have a cumulative total box that takes the totals of all 4 subreports.

The problem is that occasionally 1+ subreport may not contain any data (as the link field connecting it to the report has no record for that searched) and consequently I get an #error message, which is annoying.

Does anyone know how to get around this?

Mol

 

[JoeMiller]

You can try the Nz() function which turns a null into 0.

=Nz(Sub1)+Nz(Sub2)+Nz(Sub3)+Nz(Sub4)

HTH Joe Miller
joe.miller@flotech.net

 

[mollow]

Worked a treat mate, your a star!

Thanks,

Mol