I've got something to send on this Suzanne. As soon as I can get to my
own computer. /glenda
_____
From: DiMarco, Suzanne [mailto:SDiMarco@xxxxxxxxxxxxxxxxxx]
Sent: Thursday, June 23, 2005 08:16 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Access - Finding duplicates
I have a table in an Access database that lists patient names.
The table (consisting of Last Name, First Name fields) contains
duplicates. I need to determine how to find the dup's in a situation
where the last name is the same; however, the first name is slightly
different. For example, there may be a Smith, Mary and Smith, Mary A.
Can someone help me with an Access query or maybe dumping the names into
Excel would be better. Thank you.
Suzanne DiMarco
302-327-7517
Desktop Solutions