Need to modify query to total sum for cost and service charge

[tmartin]

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?

[June7]

Don't see benefit to DISTINCTROW and GROUP BY in the same query.

Build another query use the posted query as source and use Sum() function.

or

Use posted query as the RecordSource of a report and do summary calcs in report Header/Footer sections.

[tmartin]

Here was the query
I need to sum the cost and service charge columns. I am not familiar enough with SQL to do what you suggested. See graphic enclosure

http://www.swdev.biz/query.png

[June7]

Use the Access query builder. A query can be used just like a table to build another query. What exactly about my suggestions do you not understand?