1 2 3 4 5
| SELECT Attributions.Classification, Attributions.Code, Attributions.CodesOrientations, Sum(Attributions.[Heures totales]) AS [SommeDeHeures totales], Sum(Attributions.[Heures prestées]) AS [SommeDeHeures prestées], Attributions.Situation, Attributions.FonctionCode, Attributions.Titre, Attributions.Id_Pers, Attributions.N°
FROM Attributions
GROUP BY Attributions.Classification, Attributions.Code, Attributions.CodesOrientations, Attributions.Situation, Attributions.FonctionCode, Attributions.Titre, Attributions.Id_Pers, Attributions.N°
HAVING (((Attributions.N°)<>0))
ORDER BY Attributions.Code; |
Partager