I have a query based on a main table with outer joins to 7 lookup tables - in each case, the join includes all records from the main table and only matching records from the lookup tables. The query grid also includes 4 form-based combo boxes, and for each of those the Show box is unchecked and the criteria is set to:
Is Null or [x]
where [x] is one of the fields in the query's output.
When an item is selected in the last combo box, the query generates the error message "This expression is typed incorrectly, or it is too complex to be evaluated." When that combo box is left blank, the query runs perfectly, even if one or more of the other combo boxes have items selected from them.
I've already tried breaking this into two queries, with the problem combo box and its criteria in the second query and everything else in the first one, but the result is the same. I've found no solutions in the help screens and Microsoft's knowledge base, except for conflicting information about whether this error is more likely with one query or two. Any ideas or suggestions would be greatly appreciated. Thanks.
Is Null or [x]
where [x] is one of the fields in the query's output.
When an item is selected in the last combo box, the query generates the error message "This expression is typed incorrectly, or it is too complex to be evaluated." When that combo box is left blank, the query runs perfectly, even if one or more of the other combo boxes have items selected from them.
I've already tried breaking this into two queries, with the problem combo box and its criteria in the second query and everything else in the first one, but the result is the same. I've found no solutions in the help screens and Microsoft's knowledge base, except for conflicting information about whether this error is more likely with one query or two. Any ideas or suggestions would be greatly appreciated. Thanks.
