Combining ODBC linked tables

[sirlosi]

I have 6 ODBC linked tables to my accounting software that I would like to combine. Table names are JCT_2006CUR_Transactions, JCT_2007CUR_Transactions,.....JCT_2011CUR_Transact ions. Any help on how to combine the information in these tables one new table would be appreciated. All fields in the tables have the same format and headings.

[RuralGuy]

A UNION Query should be able to put them together for you. It will not be updateable if that make a difference.

[sirlosi]

I created the union query but i get an error stating "[Simba][SimbaEngine ODBC Driver]Non unique column reference: Job. (#0)[Simba][SimbaEngine ODBC Driver]Error in expression: % sAmount. Any help is much appreciated.

[RuralGuy]

Did you start by just putting just 2 of the queries together? Each query *must* have an equal number of fields and each corresponding field must be in the same relative position in the query and be of the same data type.

[sirlosi]

I have started only using 2. They are not queries though they are linked tables to my accounting software and they are in the exact same format.

[RuralGuy]

Can you create a SELECT * query for one of the tables?

[sirlosi]

Yes, i ran a select * query on just one table and it worked. I ran an internet search on the simba error and I seen where people running microsoft nav were having the same error which was corrected by changing their nav odbc properties to look at the field name instead of the caption, but i cant seem to find where i can change the properties on my timberline date odbc properties.

[RuralGuy]

Any assistance from the Simba software supplier available? It sounds like something specific to that software. Are you using the latest ODBC driver for this software?