I’m trying to sum a set of numbers in a report. The numbers are amounts spent by programs belonging to social service agencies. One thing that complicates matters is that, all programs made spending requests, not all requests were approved. I want to show all requests on the report, but amounts only for requests that were approved. I solved that problem with a text box with the formula: =IIf([Expr10]=0,"-- ",[Expr10]), Expr10 is the field in the query that feeds the report. In the Query Expr10 is an IIF formula. It gives either an amount, if the request was approved or a 0 if it wasn’t. The report is grouped by Agency and by Program. I tried to sum the amounts for each agency with a text box in the Agency group footer with the formula, =sum([Expr10]). When I ran the report I got the error message, “Data type mismatch in criteria expression.” I checked, and Expr10 is an integer. I also tried putting Expr10 in the group footer for Program to see whether it would sum in the Agency group footer. I still got the same error message. I also tried to set the property for Running sum to “over group.” That didn’t work either. Can anybody help?
Thanks,
Henry
Thanks,
Henry
Last edited:
