I have a subreport that totals up values displayed in the details. The sum is displayed in the report footer (the control source is '=Sum([inv_amt])'). If there are no records that meet the criteria, the sum should be 0. Instead it prints #Error. On the main report it is blank. How do I get this to print 0?