Searching more than one Table

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

 

[John Vinson]

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.

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