Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionIf Year(DTDEB) < Year(DTFIN) ThenDFA "31/12/" & Year(DTFIN) - 1: DDA "01/01/" & Year(DTFIN)Data1.RecordSource "SELECT * FROM PlanningCCKI WHERE Animateurs '" & NANIM & "'" _ & " and Dates BETWEEN '" & DateValue(DTDEB) & "' and '" & DateValue(DFA) & "'" _ & " or Animateurs = '" & NANIM & "' and Dates BETWEEN '" & DateValue(DDA) & "'" _ & " and '" & DateValue(DTFIN) & "' ORDER BY Animateurs, Dates; "