Multi-table query/search

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

Guest

I'm still new using Access and I run a db for my dept tracking training for
various projects. Is there a way to create a query that spans 3 or more
separate tables, but is only looking for the same 2 fields from each of those
tables to ensure no dupes between the tables?
 
I'm still new using Access and I run a db for my dept tracking training for
various projects. Is there a way to create a query that spans 3 or more
separate tables, but is only looking for the same 2 fields from each of those
tables to ensure no dupes between the tables?
Click to expand...

A UNION query might work, but it's awfully hard to say based on what
you've posted. It also sounds like you may have some problems with
your table design - what are these tables, and why is it necessary to
look in three tables for one piece of information?

John W. Vinson[MVP]
 
Back
Top