Find Duplicates

  • Thread starter Thread starter nath
  • Start date Start date
N

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.
 
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;
 
Back
Top