1 2 3 4 5 6 7 8 9 10
|
SELECT IIf([produit]="Plavix" Or [Produit]="Plavix 75","Plavix","Autres") AS Antiplaquettaire,
IIf([cec] Is Not Null,"CEC",IIf([coeur_battant]=True,"Coeur battant","Autres")) AS [type intervention],
Avg(T_Réanimation.[Drains H24 (ml)]) AS [Drains H24], Avg(T_Réanimation.[Drains H48 (ml)]) AS [Drains H48],
Count(DCount("[ID_patient]","T_Patient")) AS [Nombre patients]
FROM (T_Patient INNER JOIN (T_intervention INNER JOIN T_Réanimation ON T_intervention.ID_Intervention = T_Réanimation.ID_Intervention) ON T_Patient.ID_Patient = T_intervention.ID_Patient) INNER JOIN T_Medicament ON T_intervention.ID_Intervention = T_Medicament.ID_intervention
WHERE (((T_intervention.Date_intervention)>#12/31/2007#))
GROUP BY IIf([produit]="Plavix" Or [Produit]="Plavix 75","Plavix","Autres"),
IIf([cec] Is Not Null,"CEC",IIf([coeur_battant]=True,"Coeur battant","Autres"))
HAVING (((IIf([produit]="Plavix" Or [Produit]="Plavix 75","Plavix","Autres")) Not Like "")); |
Partager