>Hi,
>Can someone help me with the SQL to find all duplicates in a field?
>Thanks,
>Allen

Hi Allen,

I see, that you already received helpful replies, but just in case I would recommend you to check my Eliminating duplicates in a table FAQ #8129. I show 3 different approaches there to deal with duplicates.