A
Angel_G
Hi there.
I need to create a crosstab query that will give me the totals per column
(not by row). So that I can include the results in a linked Excel chart.
I am able to create a crosstab query that will display customer complaints
per month and give me a total for the year per item, but I need to know the
total complaints per month as well.
Is that possible in a crosstab query?
Here is my Crosstab query.
TRANSFORM Count(Charts.[QA Defect Code ID]) AS [CountOfQA Defect Code ID]
SELECT Charts.[Defect Code], Count(Charts.[Mfg Date]) AS [Total Of Mfg Date]
FROM Charts
GROUP BY Charts.[Defect Code]
PIVOT DateDiff("m",[Date Received],Date());
Thanks in advance!
I need to create a crosstab query that will give me the totals per column
(not by row). So that I can include the results in a linked Excel chart.
I am able to create a crosstab query that will display customer complaints
per month and give me a total for the year per item, but I need to know the
total complaints per month as well.
Is that possible in a crosstab query?
Here is my Crosstab query.
TRANSFORM Count(Charts.[QA Defect Code ID]) AS [CountOfQA Defect Code ID]
SELECT Charts.[Defect Code], Count(Charts.[Mfg Date]) AS [Total Of Mfg Date]
FROM Charts
GROUP BY Charts.[Defect Code]
PIVOT DateDiff("m",[Date Received],Date());
Thanks in advance!