I not a developer or programer
I need "0" to show in crosstabs
SELECT [<15 Count by insp].InspectorID, [<15 Count by insp].[Total Of
<15],
[>15 Count by insp].[Total Of =>15], [Assignment query].[6], [Assignment
query].[7], [Assignment query].Total, Failed.[Yes], [Inspections
completed].[Yes], [Progress re****ted].[Yes], [< 15 & >15 Count by insp 06
&
07 Query].[< 15 Count by insp 06_Total Of <15], [< 15 & >15 Count by insp
06
& 07 Query].[15 > Count by insp 06_Total Of =>15], [< 15 & >15 Count by
insp
06 & 07 Query].[< 15 Count by insp 07_Total Of <15], [< 15 & >15 Count by
insp 06 & 07 Query].[15 > Count by insp 07_Total Of =>15], [Failed 06 & 07
<15 & < 15 Query].[Failed 06 < 15].Total, [Failed 06 & 07 <15 & < 15
Query].[Failed 06 > 15].Total, [Failed 06 & 07 <15 & < 15 Query].[Failed
06 <
15].[NO], [Failed 06 & 07 <15 & < 15 Query].[Failed 06 > 15].[NO], [Failed
06
& 07 <15 & < 15 Query].[Failed 07 < 15].Total, [Failed 06 & 07 <15 & < 15
Query].[Failed 07 > 15].Total, [Failed 06 & 07 <15 & < 15 Query].[Failed
07 <
15].[NO], [Failed 06 & 07 <15 & < 15 Query].[Failed 07 > 15].[NO],
[Inspections completed 06 & 07 >15 & < 15 Query].[Inspections completed 07
>
15].Total, [Inspections completed 06 & 07 >15 & < 15 Query].[Inspections
completed 07 > 15_NO], [Inspections completed 06 & 07 >15 & < 15
Query].[Inspections completed 07 < 15].Total, [Inspections completed 06 &
07
>15 & < 15 Query].[Inspections completed 07 < 15_NO], [Inspections
completed
06 & 07 >15 & < 15 Query].[Inspections completed 06 < 15].Total,
[Inspections
completed 06 & 07 >15 & < 15 Query].[Inspections completed 06 < 15_NO],
[Inspections completed 06 & 07 >15 & < 15 Query].[Inspections completed 06
>
15].Total, [Inspections completed 06 & 07 >15 & < 15 Query].[Inspections
completed 06 > 15_NO], [Progress re****ted 06 & 07 > 15 & < 15 &
Query].[Total 15 < 06], [Progress re****ted 06 & 07 > 15 & < 15 &
Query].[Progress re****ted 06 < 15_NO], [Progress re****ted 06 & 07 > 15 &
<
15 & Query].[Total 06 >15], [Progress re****ted 06 & 07 > 15 & < 15 &
Query].[Progress re****ted 06 > 15_NO], [Progress re****ted 06 & 07 > 15 &
<
15 & Query].[Total 15 < 07], [Progress re****ted 06 & 07 > 15 & < 15 &
Query].[Progress re****ted 07 < 15_NO], [Progress re****ted 06 & 07 > 15 &
<
15 & Query].[Total 07 > 15], [Progress re****ted 06 & 07 > 15 & < 15 &
Query].[Progress re****ted 07 > 15_NO], [Progress re****ted 06 & 07 > 15 &
<
15 & Query].[YES]
FROM ((((((((([<15 Count by insp] INNER JOIN [>15 Count by insp] ON [<15
Count by insp].InspectorID = [>15 Count by insp].InspectorID) INNER JOIN
[Assignment query] ON [>15 Count by insp].InspectorID = [Assignment
query].InspectorID) INNER JOIN Failed ON [Assignment query].InspectorID =
Failed.InspectorID) INNER JOIN [Inspections completed] ON
Failed.InspectorID
= [Inspections completed].InspectorID) INNER JOIN [Progress re****ted] ON
[Inspections completed].InspectorID = [Progress re****ted].InspectorID)
INNER
JOIN [Progress re****ted 2] ON [Progress re****ted].InspectorID = [Progress
re****ted 2].InspectorID) INNER JOIN [< 15 & >15 Count by insp 06 & 07
Query]
ON [Progress re****ted 2].InspectorID = [< 15 & >15 Count by insp 06 & 07
Query].InspectorID) INNER JOIN [Failed 06 & 07 <15 & < 15 Query] ON [< 15
&
>15 Count by insp 06 & 07 Query].InspectorID = [Failed 06 & 07 <15 & < 15
Query].InspectorID) INNER JOIN [Inspections completed 06 & 07 >15 & < 15
Query] ON [Failed 06 & 07 <15 & < 15 Query].InspectorID = [Inspections
completed 06 & 07 >15 & < 15 Query].InspectorID) INNER JOIN [Progress
re****ted 06 & 07 > 15 & < 15 & Query] ON [Inspections completed 06 & 07
>15
& < 15 Query].InspectorID = [Progress re****ted 06 & 07 > 15 & < 15 &
Query].InspectorID;
|
