Use a make-table query to combine two existing tables

[Matt]

I have two tables that have some fields alike and some fields different. I would like to combine these tables based on a field called Term ID. There will be some records in one table that do not have a matching Term ID with the other table. Is this a problem? I created a relationship between the tables using this field. However, I only got one record after I changed views to see the results of my make-table query. I'm not familiar with make-table queries and combining tables in Access so any help would be great. If there are any rules to combining tables that you could tell me that would be great also. Thanks in advance. Matt

 

[Bill Murphy]

Matt,

You might need to do this in a couple of steps. In the first step join the
two tables with an equal join using Term ID. In this query select all the
fields from one table, then select the fields that are not alike from the
other table thereby getting all the fields. Designate this as a make table
query and run it, creating a third combined table. As a second step you
could create an unmatched query from the first two tables using the Find
Unmatched Query Wizard. Designate this query as an append query, and append
all of it's records into the third table you made with the make table query
above. This third table should then contain all the records from the first
two tables, and all the fields.

Bill

I have two tables that have some fields alike and some fields different.

I would like to combine these tables based on a field called Term ID. There
will be some records in one table that do not have a matching Term ID with
the other table. Is this a problem? I created a relationship between the
tables using this field. However, I only got one record after I changed
views to see the results of my make-table query. I'm not familiar with
make-table queries and combining tables in Access so any help would be
great. If there are any rules to combining tables that you could tell me
that would be great also. Thanks in advance. Matt