1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| SELECT " " AS _, tbl_incidenTechnique.intitulé, tbl_incidenTechnique.DteDebut AS Début,
"" AS [~], tbl_incidenTechnique.DteFin AS Fin, tbl_incidenTechnique.Impacts, "" AS[*],
IIf([DteFin]-[DteDebut]+1<=1,[DteFin]-[DteDebut]+1 & " jour",[DteFin]-[DteDebut]+1 & " jours") AS Durée,
"" AS [-], IIf(Work_Days([DteDebut],[DteFin])<=1,Work_Days([DteDebut],[DteFin]) & " jour",
Work_Days([DteDebut],[DteFin]) & " jours") AS [Travaillés]
FROM tbl_incidenTechnique;
UNION SELECT " *" AS _, "" AS intitulé, "" AS Début, "" AS [~], " " AS Fin, "" AS Impacts,
"" AS[*], "" AS Durée, "" AS [-], "" AS [Travaillés]
FROM tbl_incidenTechnique
GROUP BY "", "", "", "", " ", "", "", "", "", "";
UNION SELECT " " AS _, "" AS intitulé, " " AS Début, " TOTAL" AS [~], "INTERVENTIONS :" AS Fin,
" --------->" AS Impacts, Count(tbl_incidenTechnique.N°) AS[*], "" AS Durée, "" AS [-], "" AS [Travaillés]
FROM tbl_incidenTechnique
GROUP BY " ", "", " ", " TOTAL", "INTERVENTIONS :", " --------->", "", "", "";
UNION SELECT "*" AS _, "" AS intitulé, " " AS Début, " TOTAL" AS [~], "FUTUR :" AS Fin, " --------->" AS Impacts,
Count(tbl_interventionFuture.N°) AS[*], "" AS Durée, "" AS [-], "" AS [Travaillés]
FROM tbl_interventionFuture
GROUP BY " ", "", " ", " TOTAL", "FUTUR :", " --------->", "", "", "";
UNION SELECT "* " AS _, tbl_interventionFuture.intitulé, tbl_interventionFuture.DteDebut AS Début,
"" AS [~], tbl_interventionFuture.DteFin AS Fin, tbl_interventionFuture.Impacts, "" AS[*],
IIf([DteFin]-[DteDebut]+1<=1,[DteFin]-[DteDebut]+1 & " jour",[DteFin]-[DteDebut]+1 & " jours") AS Durée,
"" AS [-], IIf(Work_Days([DteDebut],[DteFin])<=1,Work_Days([DteDebut],[DteFin]) & " jour",
Work_Days([DteDebut],[DteFin]) & " jours") AS [Travaillés]
FROM tbl_interventionFuture;
UNION SELECT " " AS _, "Durée :" AS intitulé, " -------->" AS Début, Avg([DteFin]-[DteDebut]+1) & " jours" AS [~],
" " AS Fin, "MOYENNE" AS Impacts, " TRAVAIL :" AS[*], "--------->" AS Durée,
Avg(Work_Days([DteDebut],[DteFin])) & " jours" AS [-], "" AS [Jours Travaillés]
FROM tbl_incidenTechnique
GROUP BY "MOYENNE ", "INTERVENTION :", " -------->", "MOYENNE", " TRAVAIL :", "--------->", "";
UNION SELECT "* " AS _, "Durée :" AS intitulé, " -------->" AS Début,
Avg([DteFin]-[DteDebut]+1) & " jours" AS [~], " " AS Fin, "MOYENNE" AS Impacts,
" TRAVAIL :" AS[*], "--------->" AS Durée, Avg(Work_Days([DteDebut],[DteFin])) & " jours" AS [-],
"" AS [Jours Travaillés]
FROM tbl_interventionFuture
GROUP BY "* ", "Durée :", " -------->", "MOYENNE", " TRAVAIL :", "--------->", ""; |
Partager