Find complete record duplicates

[puforee]

I have table where each record contains many fields....30+. I need to find duplicates comparing all fields. Using the Find Duplicates Query will only allow 10 fields to be examined. I need the complete record, all fields to be examined.

Any suggestions....please.

 

[dhookom]

[ul]
[li]Make a query with the 10 fields[/li]
[li]Examine the joins with the 10 fields in design or SQL view[/li]
[li]Add the other fields[/li]
[/ul]

If you have Nulls in any field, this may cause issues since Nulls will not join with Nulls.

Duane
Hook'D on Access
MS Access MVP

 

[combo]

Alternative syntax, in design view:
- select fields where you need to find duplicates,
- in query properties mark "unique values" (resulting "SELECT DISTINCT" in query sql),
- add non-visible field with expression: "N:count([AnyField])", with condition: >1.
For conversion to unique records skip last bullet.

combo

 

[dhookom]

I like combo's solution since it is much simpler and your query involves only one table.

Duane
Hook'D on Access
MS Access MVP

 

[puforee]

Thank you both. Once I get a new data load...about a week from now...I will give this a try. If it works, as I expect it will, Stars will be given.

Thanks again,