How To Display Duplicate Records

  • Thread starter Thread starter Tiffany P. via AccessMonster.com
  • Start date Start date
T

Tiffany P. via AccessMonster.com

I have a detail form. I need to be able to click a button to search the form
for duplicate SSN's and then bring up a form that will display the duplicates.


How can I query to find duplicate SSN numbers?

Thanks,
Tiffany.....
 
Hi Tiffany

To find duplicates, use a filter or a WHERE clause similar to the following:
SSN in (select [SSN] from [YourTable] group by [SSN] having Count(*)>1 )

Just assign this string to Me.Filter and set Me.FilterOn=True.

You will probably also want to set OrderBy to "SSN" so that the groups of
duplicate records appear together.
 
Back
Top