[SOLVED] Access GROUP + SUM Problem

[hoschi111]

Ahoi,
ich habe die Lösung selbst gefunden.

SELECT Product_Groups.descr, Sum(((100-consumption.discount)/100)*consumption.pricevalue*consumption.quant) AS Summevonpricevalue FROM Consumption INNER Join (Product_Groups INNER JOIN Products ON Product_Groups.ID = Products.Group) ON Consumption.product = Products.ID WHERE (((Consumption.eventid) ='100006') AND ((Consumption.datefr)>=#12/10/2015#) AND ((Consumption.dateto)<=#12/10/2015#)) GROUP BY Product_Groups.descr, Product_Groups.ID Order By Product_Groups.ID;