ODBC Tables

[zell62]

I wonder if anyone had any suggestions regarding how to link 4 ODBC tables so the info in each of the 4 ODBC tables are in one table. The 4 ODBC tables are linked in from a mapping system. Each table has 80% the same fields with some minor differences. i dont know if a union query would be the best answer in this case as the field in each of the ODBC's tables do not exactly match. Some have 12 fields, some have 14 fields. Any help would be appreciated?
also this would be using Access 2003 if you would like to know. thanks

 

[Jibbadiah]

You can use a union query.
Select all fields from each table.
Make sure that they all have the same fieldnames.
Output '' for those tables that don't have that particular field.

Select name as field1, surname as field2, addressline1 as field3 from table1
union
Select fname as field1, surname as field2, '' as field3 from table2
union
Select '' as field1, sname as field2, address_1 as field3 from table3
... etc.