P
Patrick
Anyone,
I have a large union query (3 queries) that worked great
in Access97(don't ask). I have to upgrade to Access
2000. The query will not run after converting to Access
2000. I receive a message "This expression is typed
incorrectly, or is too complex to be evaluated...." when
the query is executed. I can run each section of the
query sucessfully. I can even run 2 different sections of
each query fine. But I can never UNION all three sections
to get a resultset. There are no numeric expressions
involved.
Any help would be incredible.
Patrick.
I have a large union query (3 queries) that worked great
in Access97(don't ask). I have to upgrade to Access
2000. The query will not run after converting to Access
2000. I receive a message "This expression is typed
incorrectly, or is too complex to be evaluated...." when
the query is executed. I can run each section of the
query sucessfully. I can even run 2 different sections of
each query fine. But I can never UNION all three sections
to get a resultset. There are no numeric expressions
involved.
Any help would be incredible.
Patrick.