Using Excel Query

Aug 10th 2009
Sift Media
Share this content

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.


Replies (0)

Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.