| 6298dep 2007-02-02, 7:16 pm |
| 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 reported].[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 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 = [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 reported] ON
[Inspections completed].InspectorID = [Progress reported].InspectorID) INNER
JOIN [Progress reported 2] ON [Progress reported].InspectorID = [Progress
reported 2].InspectorID) INNER JOIN [< 15 & >15 Count by insp 06 & 07 Query]
ON [Progress reported 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
reported 06 & 07 > 15 & < 15 & Query] ON [Inspections completed 06 & 07 >15
& < 15 Query].InspectorID = [Progress reported 06 & 07 > 15 & < 15 &
Query].InspectorID;
|