I am trying to set up a fairly complicated query. The first query pulls patient data from an ODBC database. I then have four more queries that use this query as their data source, applying more criteria. These four queries all return the same fields for their respective populations. I am trying to set up a Union Query to get all the results in one place. When I try to join the queries together with a Union Query I get an error message: "ODBC--Call Failed". I have the ODBC Timeout set to 0 for all the queries. If I change the source queries to Make-Table Queries and create tables from the query data, then change the data sources of the Union Query to the newly-made tables, the Union Query works fine (however I prefer not to have to do this every time I want to run the query again).
Is it not possible to create a Union Query based on other queries of an ODBC data source? Am I doing something wrong?
-Larry
Is it not possible to create a Union Query based on other queries of an ODBC data source? Am I doing something wrong?
-Larry
