Using Excel Query

Blogger
Share this content
0

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

Please login or register to join the discussion.

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