Query on two databases

  • Thread starter Thread starter JaneM
  • Start date Start date
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.
 
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.
 
Back
Top