filter table so to get unmatched data

  • Thread starter Thread starter musa.biralo
  • Start date Start date
M

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
 
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.
 
Back
Top