Query on two databases

J

JaneM

I am a new user in Access 2007 and would like to know if it is possible to
query two different databases? If this is possible, can you provide a sample
of the query?

Thanks in advance.
 
J

Jerry Whittle

Do you mean "databases" or "tables". In a nutshell, a database holds multiple
tables.

Assuming you mean tables that you want to join, go to the Create tab and
select Query Design. (I'm not near Access 2007 and might get some things
slightly wrong). Find the two tables that you want to join. If life is good
there will be a line joining between the two tables. Then drop down the
fields that you want to see. Run the query.
 

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

create query over two databases 0
Query Two Databases 2
Query that make table in another database 2
Passthrough Question 3
query across two access databases 5
Running ODBC query through Access on multiple databases 6
Unmatched Query? 1
Why does Access 2007 save query changes w/o prompting? 1

Top