1 2 3 4
| SELECT DISTINCTROW V.nombre, Format$([t_Resultats].[Date],'mmmm yyyy') AS [Date par mois], t_Resultats.vendor, Avg((100-([%]*100))/100) AS [% Theo], Sum([t_Resultats].[Net Win Mad])/Sum(t_Resultats.[Coin IN Mad]) AS [% Actuel], Sum(t_Resultats.JJ) AS SommeDeJJ, Sum(t_Resultats.[Coin IN Mad]) AS [Somme De Coin IN Mad], IIf(Sum([t_Resultats].[JJ])>0,Sum([t_Resultats].[Coin In Mad])/Sum([t_Resultats].[JJ]),0) AS [Av Coin In Mad], Sum(t_Resultats.[Net Win Mad]) AS [SommeDeNet Win Mad], IIf(Sum([t_Resultats].[JJ])>0,Sum([t_Resultats].[Net Win Mad])/Sum([t_Resultats].[JJ]),0) AS [Av Net Win Mad], Sum(t_Resultats.[Games Played]) AS [SommeDeGames Played], IIf(Sum([t_Resultats].[JJ])>0,Sum([t_Resultats].[Games Played])/Sum([t_Resultats].[JJ]),0) AS [Av Games Played], IIf(Sum([t_Resultats].[Games Played])>0,Sum([t_Resultats].[Coin In Mad])/Sum([t_Resultats].[Games Played]),0) AS [Mise Moyenne]
FROM t_Resultats INNER JOIN [SELECT vendor,COUNT(*) as nombre FROM t_Resultats GROUP BY vendor]. AS V ON t_Resultat.vendor = V.vendor
GROUP BY Format$([t_Resultats].[Date],'mmmm yyyy'), t_Resultats.vendor, Year([t_Resultats].[Date])*12+DatePart('m',[t_Resultats].[Date])-1
HAVING (((Format$([t_Resultats].[Date],'mmmm yyyy'))="mars 2010")); |
Partager