Hey..

I'm trying to find the sum the the 'Price' column. Can anyone give me an idea on how to do this with the following join

SELECT tblServiceLocation.Description, tblService.Description, tblVehicleService.Price,
tblVehicleService.ID, tblService.ID
FROM 
tblVehicleService, tblServiceLocation, tblService
WHERE tblVehicleService.ServiceLocationID = tblServiceLocation.ID
AND tblVehicleService.ServiceID = tblService.ID

Thanks in Advance for the help!!

-Nick

You're using Access?

At the bottom of your query, add

GROUP BY
tblServiceLocation.Description, tblService.Description

Then get rid of the tbl wart from your table names.

You forgot the SUM aggregate:

SELECT tblServiceLocation.Description, tblService.Description, SUM(tblVehicleService.Price),
tblVehicleService.ID, tblService.ID
FROM
tblVehicleService, tblServiceLocation, tblService
WHERE tblVehicleService.ServiceLocationID = tblServiceLocation.ID
AND tblVehicleService.ServiceID = tblService.ID
GROUP BY tblServiceLocation.Description, tblService.Description, tblVehicleService.ID, tblService.ID

Thank you both for the replies. Lemme give this a shot.

I like "tbl" naming convention

So these all give the same result set; basically. The SUM column gets the sum for each particular price. What I need is the total of all the sums in the price column. Does that make sense?

Thanks guys. I was able to get it done with a UNION.