I not a developer or programer
I need "0" to show in crosstabs
SELECT [<15 Count by insp].InspectorID, [<15 Count by insp].[Tot
al Of <15],
[>15 Count by insp].[Total Of =>15], [Assignment query].[6],
 [Assignment
query].[7], [Assignment query].Total, Failed.[Yes], [Inspect
ions
completed].[Yes], [Progress reported].[Yes], [< 15 & >15 Cou
nt 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 Cou
nt by
insp 06 & 07 Query].[15 > Count by insp 07_Total Of =>15], [Failed 0
6 & 07
<15 & < 15 Query].[Failed 06 < 15].Total, [Failed 06 & 07 <15 & < 15
Query].[Failed 06 > 15].Total, [Failed 06 & 07 <15 & < 15 Query].	
1;Failed 06 <
15].[NO], [Failed 06 & 07 <15 & < 15 Query].[Failed 06 > 15].	
1;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].	
1;Failed 07 <
15].[NO], [Failed 06 & 07 <15 & < 15 Query].[Failed 07 > 15].	
1;NO],
[Inspections completed 06 & 07 >15 & < 15 Query].[Inspections comple
ted 07 >
15].Total, [Inspections completed 06 & 07 >15 & < 15 Query].[Inspect
ions
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, [In
spections
completed 06 & 07 >15 & < 15 Query].[Inspections completed 06 < 15_NO],
[Inspections completed 06 & 07 >15 & < 15 Query].[Inspections comple
ted 06 >
15].Total, [Inspections completed 06 & 07 >15 & < 15 Query].[Inspect
ions
completed 06 > 15_NO], [Progress reported 06 & 07  > 15 & < 15 &
Query].[Total 15 < 06], [Progress reported 06 & 07  > 15 & < 15 &
Query].[Progress reported 06 < 15_NO], [Progress reported 06 & 07  >
 15 & <
15 & Query].[Total 06 >15], [Progress reported 06 & 07  > 15 & < 15 
&
Query].[Progress reported 06 > 15_NO], [Progress reported 06 & 07  >
 15 & <
15 & Query].[Total 15 < 07], [Progress reported 06 & 07  > 15 & < 15
 &
Query].[Progress reported 07 < 15_NO], [Progress reported 06 & 07  >
 15 & <
15 & Query].[Total 07 > 15], [Progress reported 06 & 07  > 15 & < 15
 &
Query].[Progress reported 07 > 15_NO], [Progress reported 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 = [Assignm
ent
query].InspectorID) INNER JOIN Failed ON [Assignment query].InspectorID 
=
Failed.InspectorID) INNER JOIN [Inspections completed] ON Failed.Inspect
orID
= [Inspections completed].InspectorID) INNER JOIN [Progress reported
] ON
[Inspections completed].InspectorID = [Progress reported].InspectorI
D) INNER
JOIN [Progress reported 2] ON [Progress reported].InspectorID = [
;Progress
reported 2].InspectorID) INNER JOIN [< 15 & >15 Count by insp 06 & 07 Qu
ery]
ON [Progress reported 2].InspectorID = [< 15 & >15 Count by insp 06 
& 07
Query].InspectorID) INNER JOIN [Failed 06 & 07 <15 & < 15 Query] ON [< 15 &[vbcol=se
agreen]
>15 Count by insp 06 & 07 Query].InspectorID = [Failed 06 & 07 <15 & < 15[/vbcol
]
Query].InspectorID) INNER JOIN [Inspections completed 06 & 07 >15 & < 15
Query] ON [Failed 06 & 07 <15 & < 15 Query].InspectorID = [Inspectio
ns
completed 06 & 07 >15 & < 15 Query].InspectorID) INNER JOIN [Progress
reported 06 & 07  > 15 & < 15 & Query] ON [Inspections completed 06 & 07
 >15
& < 15 Query].InspectorID = [Progress reported 06 & 07  > 15 & < 15 &
Query].InspectorID;

[ Post a follow-up to this message ]