Match Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query on two tables with matching null fields 4
Bringing data together 1
Count if query matching list 1
3 tables 8
Checking if data exists another table and, if yes, extracting a value 0
Similar data 2
Update a field from 1 through 10 6
Left Join to Huge Table with Duplicates 1

Back
Top