table idea

[teiben]

I have 3 tables, w/the same field names (imported from other db) each have a name, q1, q2, q3, etc. I need to bring them together as one if names are the same in each. (some names differ, from table to table) , any ideas how to accomplish this?

 

[Scooterbug]

You can use an append query to move the data from one table to another

 

[neileg]

Create a select queryjoining all the tables with an inner join. This will return records that exist in all three tables. Then create 3 select queries based on this query to extract the data from each table and union them together.