Simple Duplicate Record Query (1 Viewer)

[Bluezman]

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]

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]

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