Baldrick
12-06-2001, 08:45 AM
I've been running a report based off of a UNION query on 2 other queries in Access 97.
Yesterday was a happy day (I thought)because I had Crystal 8.5 installed on my machine. But now my UNION query (running in Access)does not work. The two sub-queries work fine (one is a parameter query), but I get an 'ODBC-call failed' error when I try to run the UNION query.
Is it the paramter query? To clarify, I am NOT trying to use Crystal with Access. Simply, my Access report quit working. Post hoc ergo propter hoc?
Yesterday was a happy day (I thought)because I had Crystal 8.5 installed on my machine. But now my UNION query (running in Access)does not work. The two sub-queries work fine (one is a parameter query), but I get an 'ODBC-call failed' error when I try to run the UNION query.
Is it the paramter query? To clarify, I am NOT trying to use Crystal with Access. Simply, my Access report quit working. Post hoc ergo propter hoc?