Delete From MWTRN Where [chart number] = and [case number] = and [Procedure Code] = and [date from] = and [entry number] > select [chart number], [case number], [Procedure Code], [date from], [entry number] From MWTRN Where [chart number] = and [case number] = and [Procedure Code] = and [date from] = order by [entry number]