1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| Public Sub Cotis_DuesAG(NumDebut As Integer)
Dim sSql As String
Dim q As QueryDef
sSql = "SELECT [T Adhérents].N°Adherent, [T Adhérents].Titre, [T Adhérents].Nom, [T Adhérents].Prenom, " _
& " [T Adhérents].DateAdhesion, [T Adhérents].Adresse, IIf(Mid([T Adhérents].CP,3,1)='-', Mid([T Adhérents].CP , InStr([T Adhérents].CP,'-')+1), [T Adhérents].CP) AS CP1, [T Adhérents].Ville, [T Adhérents].Pays, " _
& "[Du" & Format(NumDebut - 4, "00") & "]+[Du" & Format(NumDebut - 3, "00") & "]" _
& "+[Du" & Format(NumDebut - 2, "00") & "]+[Du" & Format(NumDebut - 1, "00") & "]" _
& "+[Du" & Format(NumDebut + 0, "00") & "]" _
& " AS [Total dû], " _
& "[T Adhérents].Du" & Format(NumDebut - 4, "00") & "," _
& "[T Adhérents].Du" & Format(NumDebut - 3, "00") & "," _
& "[T Adhérents].Du" & Format(NumDebut - 2, "00") & "," _
& "[T Adhérents].Du" & Format(NumDebut - 1, "00") & "," _
& "[T Adhérents].Du" & Format(NumDebut + 0, "00") _
& " FROM [T Adhérents] " _
& " WHERE ((([T Adhérents].Adherent) = True)) ORDER BY [T Adhérents].Nom, [T Adhérents].Prenom;"
Set q = CurrentDb.QueryDefs("R Cotis_DuesAG")
q.SQL = sSql
End Sub |
Partager