and date_inscription < 11/24/year(Now())
And year(date_inscription=year(now())) And month(date_inscription) & day(date_inscription)<1124
sql="select * from eleves where niveau='" & text1 & "' and sexe='F' and month(date_naissance) between 1 and 3 and date_inscription < 24/11/year(now) and year(date_naissance)=year(now)-5"
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionj'ai bien essayé toutes vos propositions mais rien ne change
'Filles ayant 6 ans Connection sql = "select * from eleves where niveau='" & text1 & "' and sexe='F' and (month(date_naissance) between 1 and 3) and year(date_naissance)=year(Now())-5 and (month(date_naissance)between 4 and 12) and year(date_naissance)=year(Now())-6 and date_inscription < 11/24/year(Now()) " If rs.State = 1 Then rs.Close rs.Open sql, DB, 1, 2 Dim wrdapp As Excel.Application Dim wrdDoc As Excel.Workbook Set wrdapp = New Excel.Application Set wrdDoc = wrdapp.Workbooks.Open(App.Path & "\rece.xls") wrdDoc.Application.Cells(33, 4).Value = rs.RecordCount wrdapp.Visible = True Set wrdapp = Nothing Set wrdDoc = Nothing