1 2
| SELECT Sum(IIf([DateCommande]>=DMin("DateCommande","tblCommandes") And [DateCommande]<DateSerial(Year(DMin("DateCommande","tblCommandes"))+1,Month(DMin("DateCommande","tblCommandes")),Day(DMin("DateCommande","tblCommandes"))),[Montant],0)) AS Année1, Sum(IIf([DateCommande]>=DateSerial(Year(DMin("DateCommande","tblCommandes"))+1,Month(DMin("DateCommande","tblCommandes")),Day(DMin("DateCommande","tblCommandes"))) And [DateCommande]<DateSerial(Year(DMin("DateCommande","tblCommandes"))+2,Month(DMin("DateCommande","tblCommandes")),Day(DMin("DateCommande","tblCommandes"))),[Montant],0)) AS Année2, Sum(IIf([DateCommande]>=DateSerial(Year(DMin("DateCommande","tblCommandes"))+2,Month(DMin("DateCommande","tblCommandes")),Day(DMin("DateCommande","tblCommandes"))) And [DateCommande]<DateSerial(Year(DMin("DateCommande","tblCommandes"))+3,Month(DMin("DateCommande","tblCommandes")),Day(DMin("DateCommande","tblCommandes"))),[Montant],0)) AS Année3, Sum(IIf([DateCommande]>=DateSerial(Year(DMin("DateCommande","tblCommandes"))+3,Month(DMin("DateCommande","tblCommandes")),Day(DMin("DateCommande","tblCommandes"))) And [DateCommande]<DateSerial(Year(DMin("DateCommande","tblCommandes"))+4,Month(DMin("DateCommande","tblCommandes")),Day(DMin("DateCommande","tblCommandes"))),[Montant],0)) AS Année4
FROM tblCommandes; |
Partager