Reporting from more than one data source

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi There,

The company I work for has five divisions that run five versions of the same
software package, the underlying databases have identical table structures. I
am currently having to report on each one individually and then combine the
results to obtain a complete set of stats. I have been told that there is a
way to run queries off multiple databases at the same time. If anyone has any
ideas it would be very much appreciated – although please allow for my
amateur status with Access when replying.

Thanks in advance.

(Version : Access 2003)
 
You can link to tables from multiple MDB files and rename the linked tables
to identify their source mdb. Then create a union query of the similar
linked tables. For instance:

SELECT SaleDate, SalePerson, SaleQty, SaleProductID
FROM DivAtblSales
UNION ALL
SELECT SaleDate, SalePerson, SaleQty, SaleProductID
FROM DivBtblSales
UNION ALL

SELECT SaleDate, SalePerson, SaleQty, SaleProductID
FROM DivCtblSales;
 
Back
Top