If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Use a make-table query to combine two existing tables
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
|
#2
|
|||
|
|||
Use a make-table query to combine two existing tables
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 "Matt" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|