1 2 3 4 5
| SELECT T_EMPLOYE.MATRICULE, T_EMPLOYE.PRENOM_EMPLOYE, T_EMPLOYE.NOM_EMPLOYE, Count(T_MISSION.NOM_MISSION) AS CompteDeNOM_MISSION, T_MISSION.CODE_MISSION
FROM T_EMPLOYE INNER JOIN (T_MISSION INNER JOIN T_VACATION ON T_MISSION.CODE_MISSION = T_VACATION.CODE_MISSION) ON T_EMPLOYE.MATRICULE = T_VACATION.MATRICULE
GROUP BY T_EMPLOYE.MATRICULE, T_EMPLOYE.PRENOM_EMPLOYE, T_EMPLOYE.NOM_EMPLOYE, T_MISSION.CODE_MISSION, Year([DATEJ]), T_MISSION.[INACTIF]
HAVING (((T_MISSION.CODE_MISSION) Not In ("INDISPO","P DE R","REP OB","SOLDE HS 102","SOLDE HS 87","SOLDE HS DCPP","SIJ MAT 1/2","AUD 1/2","DCPP 1/2","TSI 4","DESIST","VM","SOLDEDH64","SOLDE DH 136","AI")) And ((Year([DATEJ]))=Forms!F_Planning!An) And ((T_MISSION.[INACTIF])<>Yes))
ORDER BY Count(T_MISSION.NOM_MISSION) DESC , T_EMPLOYE.NOM_EMPLOYE DESC; |
Partager