Find Duplicates

[nath]

Hi

I dont have the wizard installed to create a find
duplicates query. Can anyone advise or show me a link on
how to use sql or design view to create these queries. I
have a table called TBL_Corp and need to find duplicates
in the field O_Number.

Cheers

Nath.

 

[Marty L]

This is the SQL generated by the wizard:

SELECT table.field
FROM table
WHERE (((table.field) In (SELECT [field] FROM

As Tmp GROUP BY
[field] HAVING Count(*)>1 )))
ORDER BY table.field;