H Humberto Registered User. Local time Today, 18:12 Joined Jan 8, 2002 Messages 40 Oct 25, 2002 #1 Is it possible to make a Query from different databases. Can someone help. Thank you.
Fuga Registered User. Local time Today, 19:12 Joined Feb 28, 2002 Messages 566 Oct 25, 2002 #2 I think the easiest way to achieve this is to link tables and then query those tables. You can also do it with DAO.recordsets. Fuga.
I think the easiest way to achieve this is to link tables and then query those tables. You can also do it with DAO.recordsets. Fuga.
J Jon K Registered User. Local time Today, 18:12 Joined May 22, 2002 Messages 2,209 Oct 27, 2002 #3 You can also use an IN clause to specify an external database e.g. SELECT Date, Amount FROM Table1 IN "C:/My Documents/db1.mdb" UNION SELECT Date, Amount FROM Table1 IN "C:/My Documents/db2.mdb";
You can also use an IN clause to specify an external database e.g. SELECT Date, Amount FROM Table1 IN "C:/My Documents/db1.mdb" UNION SELECT Date, Amount FROM Table1 IN "C:/My Documents/db2.mdb";
