Bonjour à tous

J'ai beau la tourner dans tous les sens mais je n'arrive pas à ajouter la ligne "Total" à ma Requête analyse croisée
La requête sans la ligne "Total"
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
 
TRANSFORM IIf(Count([ID_Activite]) Is Null,0,Count([ID_Activite])) AS Lavaleur
SELECT T_Activites.User AS Praticien
FROM T_Activites
WHERE (((T_Activites.User)<>"-FERME ") AND ((T_Activites.DateDebutActivite) Between [Formulaires]![F_Stats]![BeginDate] And [Formulaires]![F_Stats]![EndDate]) AND ((T_Activites.CodeActivite)<>"cm") AND ((T_Activites.CodeCreneau)=IIf([Formulaires]![F_Stats]![LstActivite]="[Tous]",[CodeCreneau],[Formulaires]![F_Stats]![LstActivite])))
GROUP BY T_Activites.User
ORDER BY T_Activites.User
PIVOT IIf(EstFerie([DatedebutActivite]),"Férié",WeekdayName(Weekday([DateDebutActivite],2))) In ("Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Férié");
Ceci ne fonctionne pas. Je ne vois pas mon erreur.

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
 
TRANSFORM IIf(Count([ID_Activite]) Is Null,0,Count([ID_Activite])) AS Lavaleur
SELECT T_Activites.User AS Praticien, Sum([ID_Activite]) AS Total
FROM
(SELECT Praticien, IIf(EstFerie([DatedebutActivite]),"Férié",WeekdayName(Weekday([DateDebutActivite],2))) In ("Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Férié"), [ID_Activite]
FROM T_Activites
UNION ALL SELECT "Total", IIf(EstFerie([DatedebutActivite]),"Férié",WeekdayName(Weekday([DateDebutActivite],2))) In ("Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Férié"), Sum([ID_Activite])
FROM T_Activites GROUP BY  IIf(EstFerie([DatedebutActivite]),"Férié",WeekdayName(Weekday([DateDebutActivite],2))) In ("Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Férié")))
WHERE (((T_Activites.User)<>"-FERME ") AND ((T_Activites.DateDebutActivite) Between [Formulaires]![F_Stats]![BeginDate] And [Formulaires]![F_Stats]![EndDate]) AND ((T_Activites.CodeActivite)<>"cm") AND ((T_Activites.CodeCreneau)=IIf([Formulaires]![F_Stats]![LstActivite]="[Tous]",[CodeCreneau],[Formulaires]![F_Stats]![LstActivite])))
GROUP BY T_Activites.User
ORDER BY T_Activites.User
PIVOT IIf(EstFerie([DatedebutActivite]),"Férié",WeekdayName(Weekday([DateDebutActivite],2))) In ("Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Férié");
La colonne dynamique des jours peut elle être simplifiée ?

Merci par avance pour vos suggestions