I need to create a Query in SQL that will group and delete all records in a table by a matching field except for the newest one.<BR><BR>THis is what i have so far:<BR><BR>DELETE FROM TableName<BR>WHERE (((TableName.Field) In (SELECT [Field] FROM [TableName] As Tmp GROUP BY [Field] HAVING Count(*)&#062;1 )))<BR><BR>But this will delete all records that contain duplicate information and i need to keep one. Thank You.