Great article

Discovering

Me.Value

though changed my life-very useful when applying the same condition across multiple cells

dealing with duplicates on a daily basis, i find this approach works well

alter table withdupes add delid int identity(1,1)

delete x

from withdupes x

inner join (

select itemno, min(delid) as keepid

from withdupes...