How do I get the total amount of sum of sales in this query?
Thanks in advance
Thanks in advance
Code:
SELECT [product history].[transaction date], [product history].[Product Code], [product history].[description one] AS Brand, Sum([product history].Quantity) AS SumOfQuantity, Sum([product history].[Sales Value]) AS [SumOfSales Value]
FROM [product history]
GROUP BY [product history].[transaction date], [product history].[Product Code], [product history].[description one];
[code]