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!
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!