I am summing the results of a calculated field from a query in a report. The report is grouped at two levels, and I need to sum at two levels. The amounts I am summing are expenditures by social service agencies. Each agency has several programs. I need a sum for each program and then for each agency. I am able to get a sum for program by putting the field (called Expr10) in the Program group footer. However, when I try to sum the sums by putting the field in the Agency group footer, I get the error message, “Data type mismatch in criteria expression.” I’ve tried it several ways: by simply putting the field in the Agency footer; by putting it in the footer and changing the Running Sum property to “over group;” and by using the formula =sum([Expr10]). I can also put the field in the Agency group footer without putting it in the Program group footer, and it will work. But I can’t put it in both places. I’ve tried other fields in the report, and I can get sums at both levels, just not Expr10. Can anybody help?
Thanks,
Henry