Here is the query
SELECT DISTINCTROW Transations.TransationID, Transations.CompanyID, Transations.EmployeeID, Transations.LocationID, DateDiff("d",[Date],Date()) AS CheckToday, Transations.Date, Transations.Time, Transations.Type, Transations.Cost, Transations.[Service Charge], Nz([Service Charge])+Nz([Cost]) AS PayAmount, Nz([Cost]) AS CostAmount
FROM Transations
GROUP BY Transations.TransationID, Transations.CompanyID, Transations.EmployeeID, Transations.LocationID, DateDiff("d",[Date],Date()), Transations.Date, Transations.Time, Transations.Type, Transations.Cost, Transations.[Service Charge], Nz([Service Charge])+Nz([Cost]), Nz([Cost])
HAVING (((Transations.LocationID)=1) AND ((DateDiff("d",[Date],Date()))=0) AND ((Transations.Type)<>"PAYMENT"));
I need to get a total sum for Cost and Service Charge. How do I modify the query to accomplish this. Should I attempt to do this in VBA code instead?