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.
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.
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.