You'll need to look at Dupes.mdb and Found.xls in the MSOfiles/Access
directory. /glenda (386-717-4664)
_____
From: Glenda Wells
Sent: Thursday, June 23, 2005 03:52 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access - Finding duplicates
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