1 2 3 4 5 6
| TRANSFORM Max(R_PlanningEleve.AbsPres) AS AbsPres
SELECT R_PlanningEleve.Eleve_id, R_PlanningEleve.Eleve, R_PlanningEleve.NumOrdre, R_PlanningEleve.PeriodeJour, R_TotalHeures.TotalHeures
FROM R_PlanningEleve LEFT JOIN R_TotalHeures ON (R_PlanningEleve.PeriodeJour = R_TotalHeures.PeriodeJour) AND (R_PlanningEleve.Eleve_id = R_TotalHeures.Eleve_id)
GROUP BY R_PlanningEleve.Eleve_id, R_PlanningEleve.Eleve, R_PlanningEleve.NumOrdre, R_PlanningEleve.PeriodeJour, R_TotalHeures.TotalHeures
ORDER BY R_PlanningEleve.Eleve, R_PlanningEleve.NumOrdre
PIVOT R_PlanningEleve.JourMois In (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31); |
Partager