>I have a large table with one field that I need to check for duplicates.
>
>I know there is a way to do a SELECT statement to do this (if I recall correclty, you have to do some type of select/having statement or something like that? Anyone know how to do this?
>
>Thanks!
select field1, count(*) as CntDups from myTable group by 1 having cntDups > 1
See also
Eliminating duplicates in a table FAQ #8129
If it's not broken, fix it until it is.
My Blog