22-09-2018, 10:30 AM
بعد جهد توصلت للحل و اود ان اشاركه معكم
-----------------------------------------------------
TRANSFORM Sum(bon_s.Quantete) AS SommeDeQuantete
SELECT stock.produit, Sum(bon_s.Quantete) AS [Total de Quantete]
FROM stock INNER JOIN bon_s ON stock.NumProduit = bon_s.NumProduit
GROUP BY stock.produit
PIVOT Format([dat],"mmm") In ("janv","févr","mars","avr","mai","juin","juil","août","sept","oct","nov","déc");
-----------------------------------------------------
TRANSFORM Sum(bon_s.Quantete) AS SommeDeQuantete
SELECT stock.produit, Sum(bon_s.Quantete) AS [Total de Quantete]
FROM stock INNER JOIN bon_s ON stock.NumProduit = bon_s.NumProduit
GROUP BY stock.produit
PIVOT Format([dat],"mmm") In ("janv","févr","mars","avr","mai","juin","juil","août","sept","oct","nov","déc");