1 2 3 4 5
| SELECT [nom_eleve] & " " & [prenom_eleve] AS NomPrenom, Matiere.nom_matiere, Compose.note_compose, Matiere.coef_matiere, [Compose]![note_compose]*[Matiere]![coef_matiere] AS note_coef, Enseignant.nom_enseignant, Classe.id_classe, Classe.nom_classe, Sequence.id_sequence, Sum([compose]![note_compose]*[matiere]![coef_matiere])/Sum([matiere]![coef_matiere]) AS MoyenneNote
FROM Sequence INNER JOIN ((Matiere INNER JOIN ((Classe INNER JOIN Eleve ON Classe.id_classe = Eleve.id_classe_fk) INNER JOIN Compose ON Eleve.id_eleve = Compose.id_eleve_fk) ON Matiere.id_matiere = Compose.id_matiere_fk) INNER JOIN Enseignant ON Matiere.id_matiere = Enseignant.id_matière_fk) ON Sequence.id_sequence = Compose.id_sequence_fk
GROUP BY [nom_eleve] & " " & [prenom_eleve], Matiere.nom_matiere, Compose.note_compose, Matiere.coef_matiere, [Compose]![note_compose]*[Matiere]![coef_matiere], Enseignant.nom_enseignant, Classe.nom_classe, Sequence.id_sequence, Eleve.nom_eleve
HAVING (((Classe.id_classe)=[Formulaires]![Choix]![nom_classe]) AND ((Sequence.id_sequence)= [Formulaires]![Choix]![id_ sequence]))
ORDER BY Eleve.nom_eleve; |
Partager