CODEWITHSUNDEEP
ms-accessduplicate-data
Jess
Jess

Reputation:

Finding Rows with Duplicate Data in MS Access

I have a large table that includes a last name and date of birth among other things. I need to write a query that returns only those rows where the last names and dates of birth are equivalent to those in another row of the table.

This a table that contains information about people who have made an application. I want to identify those who have applied more than once.

I can think of a way to do this using set operations but MS Access doesn't seem to implement them.

Thanks for your help.

Upvotes: 0

Views: 1412

Answers (3)

Tony Toews
Tony Toews

Reputation: 7882

Is there a possibility that the last name has been slightly miskeyed? Either accidentally or on purpose by the person or where the last name could be spelled differently depending on the persons original language.

If so consider using the Soundex algorithm or the first two or three characters of the first name and last name. If you are going to use the Soundex algorithm I would suggest updating the table first with the value of the Soundex field rather than computing it as you go long.

Upvotes: 1

Adrien
Adrien

Reputation: 3195

As mentioned by DJ, Access has a wizard for finding dupes. That wizard uses the HAVING clause. So, if you're saying you want to "do it in SQL", I'd suggest reading up on HAVING.

Upvotes: 0

DJ.
DJ.

Reputation: 16247

MS Access has a built-in query builder wizard for finding duplicates

http://www.databasedev.co.uk/query-wizard.html

Upvotes: 1

Related Questions