query multiple tables

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
cherrynich said:
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.
Click to expand...

I suggest checking access help file for Union Query, it will do exactly what you
want.
gm
 
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

Access Dcount (multiple criteria) 3
Export multiple tables/queries at once 1
Counting multiple memberships 1
Eliminating Cartesian Effect when Querying Multiple Tables 8
searching multiple tables 2
multiple odbc login screens 4
Delete records from multiple tables 2
Finding all queries that use a particular table 6

Back
Top