duplicate records (2000)

Topic

New Reply

I want to find duplicate records based on all fields, whereas the Find Duplicates Query Wizard limits to comparing 10 fields. Is it possible to compare ALL fields? If not, perhaps I could try creating array formulas in Excel to achieve this?? Cheers, Andy.

Reply | Quote

Replies

Make a Total Query, add all you fields, set the total line for all fields to Group by, add one more field (no matter witch), set the total line for this field to Count and in the criteria line >1

Reply | Quote

Tops, cheers.

Reply | Quote