1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| Function Sco_lex_hiver(Annee As Long)
Dim Rst As DAO.Recordset
Dim Db As DAO.Database
Dim Source As String
Set Db = CurrentDb
Source = "SELECT Count(DISTINCT INSCRITS.Num_enfant)FROM INSCRITS, SEMAINES, ENFANTS WHERE ENFANTS.Num_enfant = INSCRITS.Num_enfant AND INSCRITS.Num_semaine=SEMAINES.Num_semaine And Scolarise_lexy = True And SEMAINES.Nom IN ('H-1','H-2') And SEMAINES.Annee= " & Annee & ";"
Set Rst = Db.OpenRecordset(Source, dbOpenDynaset)
Sco_lex_hiver = Rst.Fields(0)
Rst.Close
Db.Close
Set Rst = Nothing
Set Db = Nothing
End Function |
Partager