#ERROR - HELP
I have a main report that has 3 sub reports in it. I do have 1 total text box for each sub report on the main report. Ie.: subrptProductionTotal, subrptItemizedTotal, etc... I also have 1 grand total text box that sums the totals of each sub report total. It all works fine as long as there is data in all 3 sub reports. However, if a particular sub report has no data, I receive #ERROR in that sub report total text box and also in the grand total text box. The codes I have tried do not return a value of 0 for reports that do not have any data.