Hi jwells,As visakh16 pointed out, your would get better answers from forum dedicated to access.I have tried to "disassemble" your sql and "assemble" it "my way". This is what I came up with (I have not syntax checked it, as I don't have access to an access database):select t.ID ,t.WOMin ,t.WOLabor ,isnull(p.WOParts,0) as WOParts ,isnull(o.WOOther,0) as WOOther ,isnull(p.TaxParts,0) as TaxParts ,isnull(o.TaxOther,0) as TaxOther from (select t.ID ,sum(datediff('n',tt.Start,tt.RETURN)) as WOMin ,sum(datediff('n',tt.Start,tt.RETURN) *(tt.CustRate+tt.CustRate*tt.Overtime/2) /60 ) as WOLabor from dbo.WOTrips as t inner join dbo.WOTripsTimestamps tt on tt.WOTripID=t.WOTrips.ID where t.WOID=22931 group by t.ID ) as t left outer join (select t.ID ,sum(p.Quantity*p.Price) as WOParts ,sum(p.Quantity*p.Price*0*p.taxable) as TaxParts from dbo.WOTrips as t inner join dbo.WOParts as p on p.WOTripID=t.ID where t.WOID=22931 group by t.ID ) as p left outer join (select t.ID ,sum(o.Quantity*o.Price) as WOOther ,sum(o.Quantity*o.Price*0*o.taxable) as TaxOther from dbo.WOTrips as t inner join dbo.WOOtherCharges as o on o.WOTripID=t.ID where t.WOID=22931 group by t.ID ) as o
Hope this helps you in the right direction.