1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| SELECT T_PLANNING_CLIENT.Num_protocole AS [Numéro Protocole],
T_PROTOCOLE.[Nombre de visites],
Min(T_PLANNING_CLIENT.Date) AS [Date Début],
Count(T_PLANNING_CLIENT.Date) AS [Nombre de volontaire demandé],
Sum(IIf(T_PLANNING_CLIENT.[RDV pris] = 2, 0, T_PLANNING_CLIENT.[RDV pris])) AS [Nombre de volontaire recruté],
Count(T_PLANNING_CLIENT.Date) - Sum(T_PLANNING_CLIENT.[RDV pris]) AS Delta,
IIf(T_PLANNING_CLIENT.[RDV pris] = 2, "Test Annulé",
IIf(T_PLANNING_CLIENT.[Date] <= Now(), "Test en cours", "Test à planifier")
) AS [Statut du test]
FROM T_PLANNING_CLIENT
INNER JOIN T_PROTOCOLE ON T_PLANNING_CLIENT.Num_protocole = T_PROTOCOLE.Numéro
WHERE T_PLANNING_CLIENT.Visites = 1
GROUP BY T_PLANNING_CLIENT.Num_protocole,
T_PROTOCOLE.[Nombre de visites],
IIf(T_PLANNING_CLIENT.[RDV pris] = 2, "Test Annulé",
IIf(T_PLANNING_CLIENT.[Date] <= Now(), "Test en cours", "Test à planifier")
),
T_PLANNING_CLIENT.Visites
ORDER BY T_PLANNING_CLIENT.Num_protocole; |
Partager