1 2 3 4 5 6 7 8
| strSQL = "insert into STATS ( id_etab,nbre_recl_annee,nbre_recl_annee-1,nbre_traitees_annee,"
strSQL = strSQL & "nbre_traitees_annee-1,nbre_non_traitees_annee,nbre_non_traitees_annee-1,"
strSQL = strSQL & "delai_moyen_annee,delai_moyen_annee-1,delai_cloture_annee,delai_cloture_annee-1)"
strSQL = strSQL & " Values (" & Me.ID_ETABLISSEMENT.Value & ", " & nbre_recl_annee & ", "
strSQL = strSQL & " " & nbre_recl_annee_derniere & ", " & nbre_traitees_annee & ", " & nbre_traitees_annee_derniere & ", "
strSQL = strSQL & " " & recl_non_traitees_annee & ", " & recl_non_traitees_annee_derniere & ", '"
strSQL = strSQL & " " & delai_annee & "', '" & delai_annee_derniere & "', '" & delai_cloture_annee & "', '"
strSQL = strSQL & " " & delai_cloture_annee_derniere & "')" |
Partager