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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replace Access error message with more descriptive message. 4
Duplicate record in Form and Subform 0
Check for duplicate before update 9
Error Message with Duplicate Values 10
How can I duplicate a record 1
How to pass multiple Fields to new Form 2
Duplicate a Record 7
Duplicating error 2

Back
Top