G
Guest
I need to know how to add a column to a crosstab query since the wizard only
allows one column. The columns are monthly data, but I need 2 columns for
each month,one for cost and one for price.
TRANSFORM Sum([3Q05CrPvt].EXT_PRICE) AS SumOfEXT_PRICE
SELECT [3Q05CrPvt].LOC, [3Q05CrPvt].TRANS_CODE
FROM 3Q05CrPvt
GROUP BY [3Q05CrPvt].LOC, [3Q05CrPvt].TRANS_CODE
PIVOT [3Q05CrPvt].Month;
I need this code to generate a column for EXT_PRICE and EXT_COST
allows one column. The columns are monthly data, but I need 2 columns for
each month,one for cost and one for price.
TRANSFORM Sum([3Q05CrPvt].EXT_PRICE) AS SumOfEXT_PRICE
SELECT [3Q05CrPvt].LOC, [3Q05CrPvt].TRANS_CODE
FROM 3Q05CrPvt
GROUP BY [3Q05CrPvt].LOC, [3Q05CrPvt].TRANS_CODE
PIVOT [3Q05CrPvt].Month;
I need this code to generate a column for EXT_PRICE and EXT_COST