Expression too complex to be evaluated?

[kblehman]

The control source for the Activity Summary report in my DB is the primary data table. The report contains about 12 fields, each with a statement like this one as its control source: =Sum(Abs(Year([RecDate])=Year(Date()) And ([NotifType]=9)))

Up until yesterday afternoon the report was working just fine. But suddenly when I run the report I'm getting this error:

"The expression is typed incorrectly, or it is too complex 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."

I have no idea why this problem suddenly popped up when the report had been running just fine for weeks.

Here's what I've done so far to try and fix it:
1. Copied the report and gave it a new name, thinking if the report were somehow corrupt creating a new one might fix it. No such luck.
2. Tried running the report after removing each control source statement one-by-one, but the error didn't disappear until all the statements had been cleared.

Anyone have any ideas? I'm willing to post the DB if that will help.

 

[Rich]

Why not just base the report on a totals query?

 

[kblehman]

I thought about that, but I wasn't sure if I could create a query with so much differing criteria and still get it to produce the correct calculated totals.