1 2 3 4 5 6 7 8
| PARAMETERS Forms!FCompAnnees![DateD1] DateTime, Forms!FCompAnnees![DateF1] DateTime, Forms!FCompAnnees![DateD2] DateTime, Forms!FCompAnnees![DateF2] DateTime;
TRANSFORM Sum(TDetailRemise.Montant) AS Vente
SELECT TClients.NuméroClients, TClients.Société, TDetailRemise.IDProduits
FROM (TClients INNER JOIN TRemise ON TClients.IDClients=TRemise.IDClients) INNER JOIN TDetailRemise ON TRemise.IDRemise=TDetailRemise.IDRemise
WHERE (((TRemise.RemiseDate) Between Forms!FCompAnnees![DateD1] And Forms!FCompAnnees![DateF1] Or (TRemise.RemiseDate) Between Forms!FCompAnnees![DateD2] And Forms!FCompAnnees![DateF2]))
GROUP BY TClients.NuméroClients, TClients.Société, TDetailRemise.IDProduits
ORDER BY Format([RemiseDate],"yyyy") DESC
PIVOT Format([RemiseDate],"yyyy") in (2007,2008,2009,2010,2011,2012,2013,2014); |
Partager