|
Hello,
I have the following select statement:
SELECT InspectionGraph_GetData_SelQry.month,
InspectionGraph_GetData_SelQry.[Inpsection Type],
Sum(InspectionGraph_GetData_SelQry.[0-10 Days]) AS [SumOf0-10 Days],
Sum(InspectionGraph_GetData_SelQry.[11 - 15 Days]) AS [SumOf11 - 15
Days], Sum(InspectionGraph_GetData_SelQry.[16-20 Days]) AS [SumOf16-20
Days], Sum(InspectionGraph_GetData_SelQry.[21-30 Days]) AS [SumOf21-30
Days], Sum(InspectionGraph_GetData_SelQry.[Over 30 Days]) AS [SumOfOver
30 Days]
FROM InspectionGraph_GetData_SelQry
GROUP BY InspectionGraph_GetData_SelQry.month,
InspectionGraph_GetData_SelQry.[Inpsection Type];
What I want to do is have it chart a stacked bar chart. Unfortunately
I have two values that I would like in the x axis: Month and
Inspection Type.
Can anyone tell me how I can chart two values on the x axis?
Thank you for your help!
| 
