filter table so to get unmatched data

[musa.biralo]

Hi there,

I have very simple question but i could not figure out how to get the
table.
Here are two tables:

Table A
A
B
C
D

Table B
A
D

I need a table which has all data from Table A but Table B. (unmatched
data between Table A and B)

Result Table
B
C

Thanks for your time
Musa Biralo

 

[KARL DEWEY]

Create a query in design view with both tables in the space above the grid
area. Click on the field to compare in Table A and drag to Table B. Click
on the resulting connecting line. Double click the line and select the
option that reads show all records from Table A and only those from Table B
that match. Click on the field in Table A and drag into the Field row of the
grid. Do the same for Table B into another grid space of Field row. In the
Criteria row under the Table B field type without the quotes 'Null' and run.