I am having problems with editing a cross tab query. I need to add another column into the cross tab and the column heading is in the data that i am using. I have looked at the SQL code and it is as follows:
The extra colum heading i am trying to add is "WTP" but when i add that in after the DSD then it comes up with the error meesage:
TRANSFORM Count(Tbl_BASIS_STRS_RPRT.INUMBR) AS [# of OOS]
SELECT Date() AS [Date], Tbl_BASIS_STRS_RPRT.ISTORE, [Store Table].STRNAM, Count(Tbl_BASIS_STRS_RPRT.INUMBR) AS [# of OOS]
FROM Tbl_BASIS_STRS_RPRT LEFT JOIN [Store Table] ON Tbl_BASIS_STRS_RPRT.ISTORE = [Store Table].STRNUM
WHERE (((Tbl_BASIS_STRS_RPRT.[OOS Stores w Sls])>0))
GROUP BY Date(), Tbl_BASIS_STRS_RPRT.ISTORE, [Store Table].STRNAM
ORDER BY Tbl_BASIS_STRS_RPRT.ISTORE
PIVOT Tbl_BASIS_STRS_RPRT.E3SPCD In ("DAV","MKS","DSD");
"Duplicate output alias '# of oos'
Thanks for any help in advance.