Match Query

M

Matt Dawson

I have four tables i need to use. I need to match Serial ID from Tables 1 and
2 to those in 3 and 4 i.e. Take the records from table 1 where the Serial ID
is in Table1, Table 3 and Table 4. I also need to do this for Table 2.
Any ideas?
Matt
 
J

Jeff Boyce

Matt

If you create a new query in design mode, add Table1 and Table3, and join on
the SerialID field, you can then include fields from Table1 to find matching
records.

If you need to ONLY find Table1 SerialIDs that have matches in BOTH Table3
and Table4, add Table4 also, and join from Table1!SerialID to
Table4!SerialID (as well as to Table3's SerialID).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top