Private Sub chantier_Click()
Dim SQL As String
Dim SQLWhere As String
Dim rs As DAO.Recordset
Dim resultat As String
Dim table As Variant
table = Array(1, mg, m1, m2, m3, repq1, repq2, repq3, repq4, repq5, repq6, repq7, repq8, repq9, repq10, repq11, repq12a, repq12b, repq12c, repq13, repq14, repq15, repq16)
For i = 1 To 22
SQL = "SELECT AVG(QS!" & table(i) & ") as moyenne FROM QS WHERE QS!numero <> 0 " & " And QS!date_debut >= #" & Format(Me.txtRechdebut, "mm/dd/yyyy") & "# " & " And QS!date_debut >= #" & Format(Me.txtRechfin, "mm/dd/yyyy") & "# " & " ;"
Next i
resultat = ""
Set rs = CurrentDb.OpenRecordset(SQL)
Do While Not rs.EOF
resultat = resultat & rs!moyenne
rs.MoveNext
Loop
MsgBox (resultat)
Me.mg_qs = resultat
Me.lstResults.RowSource = SQL
Me.lstResults.Requery
End Sub
l'erreur vient de la requete, il ne veut pas reconnaitre mon tableau, aurais je oublier quelque chose?
svp , aidez moi
Partager