G
Gyetko
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
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