1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| Public Sub MAJCotisDuesCR_sans_mail(Numdebut As Integer)
Dim sSql As String
Dim q As QueryDef
sSql = "TRANSFORM Sum(T_Cotisation.Cotisation_Du) AS SommeDeCotisation_Du" _
& " SELECT [T Adhérents].Titre,[T Adhérents].N°Adherent, [T Adhérents].Nom, [T Adhérents].Prenom, Sum(T_Cotisation.Cotisation_Du) AS Total, [T Adhérents].Adresse, IIf(Mid([CP],3,1)='-',Mid([CP],InStr([CP],'-')+1),[CP]) AS CP1, [T Adhérents].Ville, [T Adhérents].Pays, [T Adhérents].EMail" _
& " FROM [T Adhérents] INNER JOIN T_Cotisation ON [T Adhérents].N°Adherent = T_Cotisation.T_Adherent_FK" _
& " WHERE (((T_Cotisation.Cotisation_An) Between " & Numdebut _
& " And " & Numdebut - 4 & ") AND (([T Adhérents].Adherent)=True)) AND (([T Adhérents].EMail)=""))" _
& " GROUP BY[T Adhérents].Titre, [T Adhérents].N°Adherent, [T Adhérents].Nom, [T Adhérents].Prenom, [T Adhérents].Adresse, IIf(Mid([CP],3,1)='-',Mid([CP],InStr([CP],'-')+1),[CP]), [T Adhérents].Ville, [T Adhérents].Pays, [T Adhérents].EMail" _
& " ORDER BY[T Adhérents].Nom, [T Adhérents].Prenom" _
& " PIVOT T_Cotisation.Cotisation_An;"
Set q = CurrentDb.QueryDefs("0_R_COTIS_DUES_CR_adh_sans_mails")
q.SQL = sSql
End Sub |
Partager