G
GL
Hi,
I have a report which has three subreports. Each of the subreports has a
total that I then want to pull into the regular report to use as a
calculation. I know how to do all of this without a problem. However, the
problem arises when one of the subreports has no data for a particular
record, so instead of returning any data it returns nothing, which is ok,
except when I reference that value for my totals it comes up as an #Error -
instead I want it to come up as zero. I tried putting an if test in but
couldn't get it to know what I meant - any ideas would be so appreciated!!
GL
I have a report which has three subreports. Each of the subreports has a
total that I then want to pull into the regular report to use as a
calculation. I know how to do all of this without a problem. However, the
problem arises when one of the subreports has no data for a particular
record, so instead of returning any data it returns nothing, which is ok,
except when I reference that value for my totals it comes up as an #Error -
instead I want it to come up as zero. I tried putting an if test in but
couldn't get it to know what I meant - any ideas would be so appreciated!!
GL