Daten nach Kriterien in Access-Abfrage addieren

SELECT <Tabellenname>.<Spalte_Kunde>, <Tabellenname>.<Spalte_Produkt>, Sum(<Tabellenname>.<Spalte_Menge>)
FROM <Tabellenname>
GROUP BY <Tabellenname>.<Spalte_Kunde>, <Tabellenname>.<Spalte_Produkt>;

SELECT IIf([Invoice].[Vorgangsnummer]<>"0","044") AS Entity,   
Year([InvoiceDetail].[Datum]) AS [Year], 
Month([InvoiceDetail].[Datum]) AS [Month], 
Invoice.Artikelnummer AS ProductId, 
Material.Bezeichnung1 AS ProductName, 
InvoiceDetail.Kundennummer AS CustomerId, 
[Customer].[Name1] & " " & [Customer].[Name2] AS CustomerName,   
Invoice.Gesamtpreis AS Revenue, 
Invoice.Menge AS [Qty Sold], 
InvoiceDetail.Datum
FROM ((InvoiceDetail 
    INNER JOIN Invoice ON InvoiceDetail.Nummer = Invoice.Vorgangsnummer) 
        LEFT JOIN Material ON Invoice.Artikelnummer = Material.Artikel) 
           LEFT JOIN Customer ON InvoiceDetail.Kundennummer = Customer.Kundennummer
WHERE ((
  (InvoiceDetail.Datum)>=#1/1/2008# And (InvoiceDetail.Datum)<=#12/31/2008#) 
          AND ((InvoiceDetail.Vorgang)="D"   
                 Or (InvoiceDetail.Vorgang)="G"   
                 Or (InvoiceDetail.Vorgang)="T"   
                 Or (InvoiceDetail.Vorgang)="R")   
          AND ((Invoice.Positionstyp)=1))
GROUP BY InvoiceDetail.Kundennummer, Invoice.Artikelnummer;

SELECT IIf([Invoice].[Vorgangsnummer]<>"0","044") AS Entity,   
Year([InvoiceDetail].[Datum]) AS [Year], 
Month([InvoiceDetail].[Datum]) AS [Month], 
Invoice.Artikelnummer AS ProductId, 
Material.Bezeichnung1 AS ProductName, 
InvoiceDetail.Kundennummer AS CustomerId, 
[Customer].[Name1] & " " & [Customer].[Name2] AS CustomerName,   
Invoice.Gesamtpreis AS Revenue, 
Invoice.Menge AS [Qty Sold], 
InvoiceDetail.Datum
FROM ((InvoiceDetail 
    INNER JOIN Invoice ON InvoiceDetail.Nummer = Invoice.Vorgangsnummer) 
        LEFT JOIN Material ON Invoice.Artikelnummer = Material.Artikel) 
           LEFT JOIN Customer ON InvoiceDetail.Kundennummer = Customer.Kundennummer
WHERE ((
  (InvoiceDetail.Datum)>=#1/1/2008# And (InvoiceDetail.Datum)<=#12/31/2008#) 
          AND ((InvoiceDetail.Vorgang)="D"   
                 Or (InvoiceDetail.Vorgang)="G"   
                 Or (InvoiceDetail.Vorgang)="T"   
                 Or (InvoiceDetail.Vorgang)="R")   
          AND ((Invoice.Positionstyp)=1))
Order BY InvoiceDetail.Kundennummer, Invoice.Artikelnummer;

SELECT 
-- Year([InvoiceDetail].[Datum]) AS [Year], 
Month([InvoiceDetail].[Datum]) AS [Month], 
Invoice.Artikelnummer AS ProductId, 
FIRST(Material.Bezeichnung1) AS ProductName,
InvoiceDetail.Kundennummer AS CustomerId, 
FIRST([Customer].[Name1] & " " & [Customer].[Name2]) AS CustomerName,   

SUM(Invoice.Gesamtpreis) AS Revenue, 
SUM(Invoice.Menge) AS [Qty Sold] 
FROM ((InvoiceDetail 
    INNER JOIN Invoice ON InvoiceDetail.Nummer = Invoice.Vorgangsnummer) 
        LEFT JOIN Material ON Invoice.Artikelnummer = Material.Artikel) 
           LEFT JOIN Customer ON InvoiceDetail.Kundennummer = Customer.Kundennummer
WHERE 
  (InvoiceDetail.Datum >=#1/1/2008# And InvoiceDetail.Datum<=#12/31/2008#) 
          AND  InvoiceDetail.Vorgang IN ("D", "G", "R", "T")   
          AND Invoice.Positionstyp=1
GROUP BY Month([InvoiceDetail].[Datum]), InvoiceDetail.Kundennummer, Invoice.Artikelnummer;

SELECT Entity, Year, Month, ProductId, First(ProductName), CustomerId,  First(CustomerName), 
 Sum(Revenue),  Sum([Qty Sold]) From Abfrage_InvoiceDetails
GROUP By Entity, Year, Month, ProductId, CustomerID
ORDER By Year, Month, ProductId, CustomerID, EntityID