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 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52
| SELECT "Nb de courriers C1 envoyés", count(*) AS NB_OUI
FROM [SURVEILLANCE CPTES]
WHERE [C1]=Yes
HAVING (([SURVEILLANCE CPTES].[Date envoi C1]) Between [Début] And [Fin])
UNION
SELECT "Nb de courriers C2 envoyés", count(*) AS NB_OUI
FROM [SURVEILLANCE CPTES]
WHERE [C2]=Yes
HAVING (([SURVEILLANCE CPTES].[Date envoi C2]) Between [Début] And [Fin])
UNION
SELECT "Nb de dossiers CLASSES", count(*) AS NB_OUI
FROM [SURVEILLANCE CPTES]
WHERE [Justifié]=Yes
HAVING (([SURVEILLANCE CPTES].[Date justification]) Between [Début] And [Fin])
UNION
SELECT "Nb de courriers CLOTURE envoyés", count(*) AS NB_OUI
FROM [SURVEILLANCE CPTES]
WHERE [Clôture]=Yes
HAVING (([SURVEILLANCE CPTES].[Date de clôture]) Between [Début] And [Fin]);
UNION
SELECT "Nb de dossiers REOUVERTS", count(*) AS NB_OUI
FROM [SURVEILLANCE CPTES]
WHERE [Réouvert]=Yes
HAVING (([SURVEILLANCE CPTES].[Date de réouverture]) Between [Début] And [Fin]);
UNION
SELECT "Nb de dossiers DEROGES", count(*) AS NB_OUI
FROM [SURVEILLANCE CPTES]
WHERE [Dérogation]=Yes
HAVING (([SURVEILLANCE CPTES].[Date de dérogation]) Between [Début] And [Fin]);
UNION
SELECT "Nb de COMPTES CLOTURES", count(*) AS NB_OUI
FROM [SURVEILLANCE CPTES]
WHERE [Clôture effective]=Yes
HAVING (([SURVEILLANCE CPTES].[Date dérogation après clôture]) Between [Début] And [Fin]);
UNION SELECT "Nb de TRAITEMENT sur la période " AS Expr1, Count(*) AS NB_OUI
FROM [SURVEILLANCE CPTES]
WHERE ((([SURVEILLANCE CPTES].[Date de traîtement]) Between [Début] And [Fin])); |
Partager