Show data not in table A using multiple fields

[mikesmith01]

I have two tables, A & B. Table A has two fields ("Claim Key" and "MY"). Table B has 24 fields. Two of these fields are ("Claim Key" and "MY"). I want to search table B and show ("Claim Key" and "MY") if they are not listed in table A.

EXAMPLE:
Table A Table B
CLAIM KEY MY CLAIM KEY MY
1a 10 1a 10
2a 10 2a 10


2a 09 2a 09
54f 12 6h 07
51f 08
54f 12

I would only like to show 6h 07 and 51f 08.

I would prefer to do this in the Design View, since I am new to Access.

[jzwp11]

Welcome to the forum!

I believe the unmatched query wizard should give you what you want.

[mikesmith01]

I could not figure out how to use to fields in the unmatched query. I am brand new to Access. Can somone please give me basic steps. Thanks.

[jzwp11]

This might be a formatting issue but this statement from your original post does not make sense with the data you presented earlier

I would only like to show 6h 07 and 51f 08.

I am guessing that your table data should have looked more like this:

EXAMPLE:
Table A
CLAIM KEY MY
1a 10
2a 10
2a 09
54f 12

Table B
CLAIM KEY MY
1a 10
2a 10
2a 09
6h 07
51f 08
54f 12


Since you have two fields by which you want to match, you have to modify the unmatched query that is generated by the wizard since it allows you to only join by 1 field. Therefore, I have attached a Word document with screen shots that walk you through the process.