1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| SELECT
Établissement.Nom,
Établissement.[Nb/trav] AS Nb,
Left([Techniciens].[Nom],4) AS Tech,
Left([Infirmiiere].[Nom],4) AS Inf,
IIf(IsNull([Planif Hyg - Colonne (MEA)].[Établissement]),"","X") AS MEA,
IIf(IsNull([Planif Hyg - Colonne (Béryllium)].[Etablissement]),"","X") AS [Béryllium (< 2007)],
IIf(IsNull([Planif Hyg - Colonne (Amiante)].[Etablissement]),"","X") AS [Amiante (< 2007)],
IIf(IsNull([Planif Hyg - Colonne (CP)].[Etablissement]),"","X") AS [CP (< 2008)],
IIf(([Secteur Prioritaire]<400) And ([Aucun risque retenu]=False) And ([Date PSSE]<1999),"X","") AS [MAJ 06-08],
IIf(IsNull([Planif Hyg - Colonne (Elab)].[Etablissement]),"","X") AS Elab, IIf(IsNull([Planif Hyg - Colonne (EVAL)].[Établissement]),"","X") AS Eval,
IIf(Not IsNull([Planif Hy - Colonne (Relance 06-08)].[Établissement]),"X","") AS [Relance 06-08],
IIf(IsNull([Planif Hyg - Colonne (A/D)].[Établissement]),"","X") AS [À dét],
IIf(IsNull([Planif Hyg - Colonne (Int)].[Établissement]),"","X") AS Inter
FROM (((((((((Techniciens RIGHT JOIN (Infirmiiere RIGHT JOIN Établissement ON Infirmiiere.Noauto = Établissement.Infirmière) ON Techniciens.Noauto = Établissement.Tech) LEFT JOIN [Planif Hyg - Colonne (EVAL)] ON Établissement.noauto = [Planif Hyg - Colonne (EVAL)].Établissement) LEFT JOIN [Planif Hyg - Colonne (MEA)] ON Établissement.noauto = [Planif Hyg - Colonne (MEA)].Établissement) LEFT JOIN [Planif hyg - Colonne (Int)] ON Établissement.noauto = [Planif hyg - Colonne (Int)].établissement) LEFT JOIN [Planif Hyg - Colonne (Béryllium)] ON Établissement.noauto = [Planif Hyg - Colonne (Béryllium)].Etablissement) LEFT JOIN [Planif Hyg - Colonne (amiante)] ON Établissement.noauto = [Planif Hyg - Colonne (amiante)].Etablissement) LEFT JOIN [Planif Hyg - Colonne (CP)] ON Établissement.noauto = [Planif Hyg - Colonne (CP)].Etablissement) LEFT JOIN [Planif Hyg - Colonne (Elab)] ON Établissement.noauto = [Planif Hyg - Colonne (Elab)].Etablissement) LEFT JOIN [Planif Hyg - Colonne (A/D)] ON Établissement.noauto = [Planif Hyg - Colonne (A/D)].Établissement) LEFT JOIN [Planif Hy - Colonne (Relance 06-08)] ON Établissement.noauto = [Planif Hy - Colonne (Relance 06-08)].Établissement
WHERE (((Établissement.Statut)=False))
ORDER BY Établissement.Nom; |
Partager