I have a main report that contains three subreports. All three subreports are supplied by select queries, the three subreports may or may not contain data. When one or more does not contain data I get an #error msg for my subtotal. I've been trying to use a combination of the IIf and HasData functions to eliminate this problem but to no avail. Any help would be appreciated
Yes I've tried the Nz() function, except that if I have more than one total it only picks up the last one. For example if I have:
I would get a sum of the second and third items and the null (zero) but not the first. And when I try to use the Sum() function with Nz() I get errors.