Hello - I have an Access 2013 report based on a collection of queries with aggregate sums, all rolled up and connected to the final query. These sums also have field calculations before they are summed. By the time I get to the report, the report can't seem to handle any of the options in summing the fields. When using Sum(Field), ether get an error:
"The expression is typed incorrectly, or it's too complicated to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables."
Its not really practical to try and directly reference the root fields originally used in the base queries, as they are too deep into the nesting. I would probably have to rewrite all of the queries, which I would like to avoid. The other approach is possibly using a DSum tying into the key field on the report, but that's not the most elegant solution.
I would like to know if there is any other work around for dealing with these more complicated fields to simply get them to sum on the report footer. Thanks.