Hello,
I have the following crosstab query.
TRANSFORM Sum(qryBldg_2.[Valin repcur]) AS [SumOfValin repcur]
SELECT qryBldg_2.[Cost element name], Sum(qryBldg_2.[Valin repcur]) AS [Total Of Valin repcur]
FROM qryBldg_2
WHERE (((qryBldg_2.Location)="BCHM") AND ((qryBldg_2.[Fiscal Year])="2018"))
GROUP BY qryBldg_2.[Cost element name]
PIVOT qryBldg_2.[Order Type];
For [Order Type], there are (10) different types (Example: A thru J). Is there a way to group/sum the Order Types for Column Headers?


