Union Qry from 2 Databases

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

I have a database that is approx 600MB. I am moving 450MB
to a second database because that will be basically
history for lookup purposes. I want to be able to query
records in the second database with records in the main
database for history lookups.

How can I UNION a query from the main database with a
query in the second database so when I open a form I can
get the entire group of records I want?

Thanks for your help.

Steven.
..
 
In your "Live" database, create a link to the history
table, move the query from the history database to the
live database, and use this in your union query
 
Make a database with a dynamic link to the 2 tables in the 2 databases.
(Import tables - connection)
so this database has a link to a table in database 1 and a link
to table in database 2

In this database:
make query1 with all of the data in table1
make query2 with all of the data in table2
make query3 in SQL - vieuw:
copy the SQL formula from query 1 into the SQL from query3
at the end type: "union"
copy the sql formula from query2 into the sql from query3, behind the
word Union
save this query3 and delete query1 and query2
Query3 will give you a list with all the records from database 1 and
database 2.

QED
 
Back
Top