This query has worked for a long time - but suddenly is throwing this error
This is the query and the criteria coming from a form input
This is the data in the table I am querying
On the form the user is entering an ending date like 08/31/14. The query had been able to translate that to 08 2014 - and the results were correct. I don't know why I'd suddenly be getting the "too complex" error. I reasoned that I could change my query to look at the posting-dt column instead of post-period and post-year, but I cannot since some records have a posting date that is not the same as the post-period.
I tried adding two new input field for the user to enter a post-period and post-year to use that as the criteria instead of the expression, but that did not work (returned in correct number of records).
I'd really like for this query to work as it has all along. Can an expert suggest a fix for this or point out why it may be failing?