1 2 3 4 5 6 7 8 9
| SELECT StockAc.NumPiece,
StockAc.Produit.DesignationPiece AS Expr1,
Sum(StockAc.Sorties) AS SommeDeSorties,
Sum(StockAc.Entrées) AS SommeDeEntrées,
Sum(StockAc.[Stock actuel]) AS [SommeDeStock actuel], Sum([Entrées]+[Stock actuel]) AS CMUP_Qte, Sum(StockAc.MontantStockActu) AS SommeDeMontantStockActu, Sum([Montant_Entrees]+[MontantStockActu]) AS CMUP_MT, [CMUP_MT]/[CMUP_QTE] AS CMUP,
StockAc.NumPiece
FROM StockAc
GROUP BY StockAc.NumPiece, StockAc.Produit.DesignationPiece, StockAc.NumPiece; |
Partager