I have a report and two sub reports. The main report is calculating an addition on a sum from each of the sub reports. The problem comes when one of the subreports has no data. The addition in the main form will then print an #error. I assume it is because the subform contains no data and trying to add a non existant value which gives the error.
If a subreport has no data, can I set a default value to use? How do I get around this error?
If a subreport has no data, can I set a default value to use? How do I get around this error?