1 2 3
| SELECT Sheet1.Endroit, Sheet1.[Num facture], Sheet1.[Date factur#], Sheet1.[Actual Good Issue Date], Sheet1.Donneur, Sheet1.[Nom donneur], Sheet1.Récept, Sheet1.[Récept Nom], Sheet1.Produit, Sheet1.Article, Sheet1.[Decript# produit ], Sheet1.UQté, Sheet1.Quantité, Sheet1.Valeur, Sheet1.[Sous-total 4], [Sheet2].Endroit, [Sheet2].[ Produit], Avg([Sheet2].[Coût]) AS [MoyenneDeCoût]
FROM Sheet1 INNER JOIN [Sheet2] ON (Sheet1.Endroit=[Sheet2].Endroit) AND (Sheet1.Produit=[Sheet2].[Produit])
GROUP BY Sheet1.Endroit, Sheet1.[Num facture], Sheet1.[Date factur#], Sheet1.[Actual Good Issue Date], Sheet1.Donneur, Sheet1.[Nom donneur], Sheet1.Récept, Sheet1.[Récept Nom], Sheet1.Produit, Sheet1.Article, Sheet1.[Decript# produit ], Sheet1.UQté, Sheet1.Quantité, Sheet1.Valeur, Sheet1.[Sous-total 4], [Sheet2].Endroit, [Sheet2].[ Produit]; |
Partager