Ok, I have 3 tables 1) New, 2) Current, and 3) History. All 3 have identical data structures. I am trying to do a Union query in Access, but I get the following error:
[Timberline][Timberline ODBC Dri(#0)[Timberline][Timberline ODBC Driver](#0)
The funny thing is I can get the query to work fine in Crystal Reports SQL Query Designer. I have tried to restart everything, kicked everyone out of the DB, Refreshed the links to the Timberline tables, yet nothing works. Any ideas? Below is my code, notice how terribly basic it is...
UNION SELECT *