I think I need something like this

But I really have my where clause screwed up !!!

sELECT distinct dbo.RECORDED_SERVICE.OID, MAX(dbo.RECORDED_SERVICE.STARTTIME) AS Expr1, dbo.SERVICE_ITEM.SERVICE_ITEM_DESCRIPTION, dbo.CostCenter.AbbrName,

dbo.Recorded_Service_Helper.Client_ID

FROM dbo.CostCenter INNER JOIN

dbo.AGENCY_COST_CENTER ON dbo.CostCenter.OID = dbo.AGENCY_COST_CENTER.COST_CENTER_MONIKER INNER JOIN

dbo.RECORDED_SERVICE INNER JOIN

dbo.Recorded_Service_Helper ON dbo.RECORDED_SERVICE.OID = dbo.Recorded_Service_Helper.Recorded_Service_OID INNER JOIN

dbo.CostCtrGrp ON dbo.Recorded_Service_Helper.CostCtrGrp_OID = dbo.CostCtrGrp.OID INNER JOIN

dbo.SERVICE_ITEM ON dbo.RECORDED_SERVICE.SERVICE_ITEM_MONIKER = dbo.SERVICE_ITEM.OID ON

dbo.AGENCY_COST_CENTER.OID = dbo.CostCtrGrp.CostCenter

where STARTTIME <

(select MAX(starttime) from RECORDED_SERVICE where OID = RECORDED_SERVICE.OID)