I've posted an example of the Query results I would like returned from
my Data Source.  Basically, I want to have one row for each item, then
have columns for the Months and show the Qty for that Item under the
given Month.  I know I can get my desired results using VBA, but was
wondering if it could be done with straight SQL.  Thank you.

Data Source:
Item      Month     Qty
---------   ---------     ------
12345       1          50
12345       2          65
12345       3          42
67890       1          15
67890       2          11
67890       3          26

Query Results:
Item      QtyMonth1   QtyMonth2   QtyMonth3
---------   ----------------   ----------------   ----------------
12345         50                 65               42
67890         15                 11               26