How do I find matching data in two Access tables?

L

LovelyLaura

I have created a small Access database that has at present only two tables. I
would like to find all the records that appear in one table and the other as
identical matches i.e. identical postcodes in both tables.

How do you find all the records that appear in both tables?
 
K

KARL DEWEY

Create a query and in the design view drag the matching field from one to the
other. Run the query and only where the two fields match will it display the
record.
 
Top