1 2 3 4
| SELECT DISTINCTROW Format$(Rdv.[Date Rdv],'mmmm yyyy') AS [Date Rdv par mois], Sum(Rdv.Cb) AS [TOT CB], Sum(Rdv.Chq) AS [TOT CHQ], Sum(Rdv.Esp) AS [TOT ESP], Sum([Cb]+[Chq]+[Esp]) AS [TOT CA MOIS], Count(*) AS [NBR Rdv], Avg([Cb]+[Chq]+[Esp]) AS [PANIER MOY], Max([Cb]+[Chq]+[Esp]) AS [PLUS GROS RDV] , format(Rdv.[Date Rdv],'yyyymm')
FROM Rdv
GROUP BY Format$(Rdv.[Date Rdv],'mmmm yyyy'), Year(Rdv.[Date Rdv])*12+DatePart('m',Rdv.[Date Rdv])-1 , format(Rdv.[Date Rdv],'yyyymm')
ORDER BY format(Rdv.[Date Rdv],'yyyymm') |
Partager