query multiple tables

J

John Vinson

Can I query multiple tables at once and if so how????
thank you.
Click to expand...

Yes; by using a joined query or a UNION query.

For a more detailed answer please post a more detailed question. What
are these tables? How are they related? Are they multiple tables
containing different subsets of the same data, or are they in
one-to-many relationships? What kind of search do you want to perform?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
C

cherrynich

the tables are all from the same excel template. exactly the same fields,
different data in the fields. I want to query them as if they were one large
table. thank you.
 
Top