i posted my sample in the access are of the file. hope it helps. /glenda
_____
From: Pearce, Norman [mailto:Norman.Pearce@xxxxxxxxxx]
Sent: Thursday, June 23, 2005 09:45 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Access - Finding duplicates
Glenda
Could you paste the SQL statement to the list, I'm sure others
would be interested, including myself
Norman Pearce
Building the foundations for your success
Ealing Hospital
UK
-----Original Message-----
From: Glenda Wells [mailto:gwells@xxxxxxxxxxx]
Sent: 23 June 2005 14:33
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access - Finding duplicates
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