SELECT Temp.[Tracking Number Ren], Temp.[Renewed Ticket Date], Temp.[Renewed Ticket Number], Temp.[Ren Exp Date], Temp.[Utility Locate Co], Temp.[Loc Renewal Date], Temp.FD, Temp.HD, Temp.H
FROM Temp
GROUP BY Temp.[Tracking Number Ren], Temp.[Renewed Ticket Date], Temp.[Renewed Ticket Number]...