Using Excel Query
One can go "FAR" in today's world of financial reporting if one can get Fast, Accurate & Reliable data to manage. Microsoft query is a means to create a report made from elements of multiple databases. This exercise will show how to write a query in Excel. The example will link two Microsoft Access tables , and use a pivot table using a calculated field to reconcile the difference. For your convenience, this tutorial is available for download.