I have the name and the month grouped. The numbers are all sum
Code:
SELECT Customer.[Sales Person], [Delivery].[Month] & ": " & MonthName([Delivery].[Month],True) AS [Month], Sum(Delivery.[Kgs Sold]) AS [SumOfKgs Sold], Sum(Delivery.[include VA Extended Value]) AS [SumOfinclude VA Extended Value], Sum(Delivery.[net of VAT]) AS [SumOfnet of VAT], Sum(Delivery.[Billed USD]) AS [SumOfBilled USD]
FROM Delivery LEFT JOIN Customer ON Delivery.Customer = Customer.[Customer Name]
WHERE (((Delivery.Customer) Is Not Null))
GROUP BY Customer.[Sales Person], [Delivery].[Month] & ": " & MonthName([Delivery].[Month],True);
IF IT HELPS