I have the following code for one of my Crosstab queries. My question relates to the 'PIVOT' part of the code. Am I able to include another PIVOT argument that will show all the rows? Do I add 'AND to the argument? I need to show all rows and columns. Thank you for any assistance you can offer.
Code:
TRANSFORM CLng(Nz(Count([01 REG COMP - 32477].Acty_Cntct_Typ_Nm),0)) AS CountOfActy_Cntct_Typ_Nm
SELECT [01 REG COMP - 32477].Intractn_Sts, Count([01 REG COMP - 32477].Acty_Cntct_Typ_Nm) AS [Total Of Acty_Cntct_Typ_Nm]
FROM [01 REG COMP - 32477]
GROUP BY [01 REG COMP - 32477].Intractn_Sts
PIVOT [01 REG COMP - 32477].Rating In ("P1","P2","P3","P4","P5","P6","P7","P8","P9","PO ASAP");