1 2 3 4
| SELECT Format([Date],"mm-dd") AS Jour, Sum(IIf(Year([Date])=2009,[Somme De Coin In Mad],0)) AS [Coin In Mad 2009], Sum(IIf(Year([Date])=2010,[Somme De Coin In Mad],0)) AS [Coin In Mad 2010], Sum(IIf(Year([Date])=2011,[Somme De Coin In Mad],0)) AS [Coin In Mad 2011], Sum(IIf(Year([Date])=2012,[Somme De Coin In Mad],0)) AS [Coin In Mad 2012], Sum(IIf(Year([Date])=2013,[Somme De Coin In Mad],0)) AS [Coin In Mad 2013], Round(DAvg("[Coin In Mad 2012]","[R_Resultats_jours]"),2) AS [Moyenne CI 2012], Round(DAvg("[Coin In Mad 2013]","[R_Resultats_jours]"),2) AS [Moyenne CI 2013]
FROM R_Resulat_journalier
GROUP BY Format([Date],"mm-dd")
ORDER BY Format([Date],"mm-dd"); |
Partager