I have a query that has worked fine for months, now out of nowhere I am getting an "Error 3071" msg. The exact msg is:
This 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. (Error 3071)
I have gotten the error before if I have made my queries too complicated (too many queries linked together). But this particular query is fairly simple, it is ran based on a parameter (a 5 digit order number)that is received from an outside source. The query errs out only if it receives 1 specific order number. It runs fine with all others. Is it possible that there may be a control character somewhere within the data associated with that order? I'm a bit stumped at this time.. any ideas out there??
TIA RLW
This 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. (Error 3071)
I have gotten the error before if I have made my queries too complicated (too many queries linked together). But this particular query is fairly simple, it is ran based on a parameter (a 5 digit order number)that is received from an outside source. The query errs out only if it receives 1 specific order number. It runs fine with all others. Is it possible that there may be a control character somewhere within the data associated with that order? I'm a bit stumped at this time.. any ideas out there??
TIA RLW