1 2 3 4
| SELECT [nom_eleve] & " " & [prenom_eleve] AS NomPrenom, Matiere.Groupe, Matiere.nom_matiere, Compose.note_compose, Matiere.coef_matiere, [Compose]![note_compose]*[Matiere]![coef_matiere] AS note_coef, IIf([Compose].[note_compose] Between 0 And 2.99,'Nul',IIf([Compose].[note_compose] Between 3 And 5.99,'Très Faible',IIf([Compose].[note_compose] Between 6 And 7.99,'Faible',IIf([Compose].[note_compose] Between 8 And 8.99,'Insuffisantl',IIf([Compose].[note_compose] Between 9 And 9.99,'Médiocre',IIf([Compose].[note_compose] Between 10 And 11.99,'Passable',IIf([Compose].[note_compose] Between 12 And 13.99,'Assez-bien',IIf([Compose].[note_compose] Between 14 And 15.99,'Bien',IIf([Compose].[note_compose] Between 16 And 17.99,'Très-bien',IIf([Compose].[note_compose] Between 18 And 19.99,'Excellent',IIf([Compose].[note_compose]=20,'Parfait'))))))))))) AS Apprecier, Enseignant.nom_enseignant, Classe.nom_classe, Sequence.valeur, Eleve.id_eleve, ElementDiscipline.Nom_element, Discipline.Absence, [Rang Sequentiel].Rang
FROM Sequence INNER JOIN ((Matiere INNER JOIN (((Classe INNER JOIN (Eleve INNER JOIN [Rang Sequentiel] ON Eleve.id_eleve = [Rang Sequentiel].id_eleve) ON Classe.id_classe = Eleve.id_classe_fk) INNER JOIN Compose ON Eleve.id_eleve = Compose.id_eleve_fk) INNER JOIN (ElementDiscipline INNER JOIN Discipline ON ElementDiscipline.id_element = Discipline.id_element) ON Eleve.id_eleve = Discipline.id_eleve) ON Matiere.id_matiere = Compose.id_matiere_fk) INNER JOIN Enseignant ON Matiere.id_matiere = Enseignant.id_matière_fk) ON (Sequence.id_sequence = Discipline.id_sequence) AND (Sequence.id_sequence = Compose.id_sequence_fk)
GROUP BY [nom_eleve] & " " & [prenom_eleve], Matiere.Groupe, Matiere.nom_matiere, Compose.note_compose, Matiere.coef_matiere, [Compose]![note_compose]*[Matiere]![coef_matiere], IIf([Compose].[note_compose] Between 0 And 2.99,'Nul',IIf([Compose].[note_compose] Between 3 And 5.99,'Très Faible',IIf([Compose].[note_compose] Between 6 And 7.99,'Faible',IIf([Compose].[note_compose] Between 8 And 8.99,'Insuffisantl',IIf([Compose].[note_compose] Between 9 And 9.99,'Médiocre',IIf([Compose].[note_compose] Between 10 And 11.99,'Passable',IIf([Compose].[note_compose] Between 12 And 13.99,'Assez-bien',IIf([Compose].[note_compose] Between 14 And 15.99,'Bien',IIf([Compose].[note_compose] Between 16 And 17.99,'Très-bien',IIf([Compose].[note_compose] Between 18 And 19.99,'Excellent',IIf([Compose].[note_compose]=20,'Parfait'))))))))))), Enseignant.nom_enseignant, Classe.nom_classe, Sequence.valeur, Eleve.id_eleve, ElementDiscipline.Nom_element, Discipline.Absence, [Rang Sequentiel].Rang, Eleve.nom_eleve, Classe.id_classe, Sequence.id_sequence
HAVING (((Classe.id_classe)=[Formulaires]![Bulletin séquentiel]![ListeClasse]) AND ((Sequence.id_sequence)=[Formulaires]![Bulletin séquentiel]![Sequence])); |
Partager