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?
 
Post your table structure, example of data, and what results you expect.
 
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]
 
You must log in or register to reply here.

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

Multiple Table Search 15
Cleaner way to query for negatives? 3
Query Confusion 16
ow do I run a multi-table query? 3
search multiple criteria 0
Query to find select columns in several tables....Help! 2
Append Query in MS Access 1
Counting multiple memberships 1

Back
Top