unmatched data

[JIM.H.]

Hello,
I have two different tables with different fields. I need
to check if two fields in these tables match or not. I
need to exclude matched ones and create another table
with the unmatched data from both tables. Unmatched
wizard does not help me because it only brings the
unmatched data from one of the table.
How can I do that?
Thanks,
Jim.

 

[Les]

Hi Jim,
1)Create a table that can hold all your different fields.
2)Use the unmatched query to get all the unmatched records
from table 1. Then, once the query is built, change it to
an append query. Append the unmatched records in to your
newly created table.
3)Use the unmatched query to get all the unmatched records
from table 2. Then, change it to an append query. That
should give you all your unmatched records into a new
table.

 

[John Vinson]

Hello,
I have two different tables with different fields. I need
to check if two fields in these tables match or not. I
need to exclude matched ones and create another table
with the unmatched data from both tables. Unmatched
wizard does not help me because it only brings the
unmatched data from one of the table.
How can I do that?
Thanks,
Jim.

You'll probably have to do this in two append queries, one from the
records in TableA which don't have matches in TableB, and another vice
versa. I guess I don't understand how this new table is structured;
what fields do you have in these two tables, and what fields would be
in the new table?