View Full Version : Simple Duplicate Record Query


Bluezman
02-13-2002, 06:00 AM
This should be very easy, but I'm having brain-freeze and can't figure this out. I want a query that will list all duplicate records where the LastName and FirstName are the same.

Thanks to anyone that can help out!

Bluez

David R
02-13-2002, 06:50 AM
Here, have a bowl of chili. It's February, be glad it's only a soft freeze.

Look at the Queries window, New Query, Find Duplicates wizard. You can specify more than one field.
You may have to go into the SQL of it and change an OR to an AND, I don't recall.

HTH,
David R

Bluezman
02-13-2002, 07:29 AM
Thank you David.... worked like a charm. Now the girlfriend is complaining about the results of the chili, but that's another message board entirely :-)

Appreciate the help!

Bluez