Searching more than one Table

  • Thread starter Thread starter Alvin Negron-Paez
  • Start date Start date
A

Alvin Negron-Paez

Hi:

I created three tables using Excel, which I imported to
Access 2000. I'm trying to find a way to look up the same
text in all three tables at the same time. I've been
trying to program Queries for things that I know are in
all three Tables but I've not been succesful. Any and al
assistance will be greatly appreciated. Thank you.
 
To find things in multiple tables you perform a JOIN of two tables on the
common field.
This JOIN automatically restricts the records to those in common (unless you
change the JOIN from INNER to LEFT or RIGHT.)

You can then JOIN your third table to the other two.

The datatypes and data should be identical if you expect to get any
meaningful results.
Coming from Excel, I wouldn't count on it!
 
Hi:

I created three tables using Excel, which I imported to
Access 2000. I'm trying to find a way to look up the same
text in all three tables at the same time. I've been
trying to program Queries for things that I know are in
all three Tables but I've not been succesful. Any and al
assistance will be greatly appreciated. Thank you.
Click to expand...

If you want to string the three tables together "end to end" and find
a record, regardless of which table it's in, a UNION query would be
the ticket. See the online help for UNION (post back if the Help file
lets you down).
 
Back
Top