Bringing data together

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

Guest

I have two tables and I need to bring the matching Serial IDs from both
tables to produce the related fields i.e. Table one Serial ID matched with
Table two Serial ID which then produces the related records based on the one
Serial ID
Many Thanks,
Matt
 
Just include both tables in your query and draw a link (relationship)
between the two tables. Then add the needed fields from the tables to the
query.
 

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

Similar data 2
Match Query 1
3 tables 8
Delete Query 3
Query criteria problem 5
Delete Related records 2
append query creating new records 2
Modifying a field in one table with data from another table 2

Back
Top