<[EMAIL PROTECTED]cc:
>Fax to:
Subject: RE: Weeding out duplic
without the Internet and the amazing resource it makes everyone!
Regards,
Jonathan Duncan
>>>"Robert A. Rosenberg" <[EMAIL PROTECTED]> 07/10 8:09 pm >>>
At 17:25 -0600 on 07/09/2004, Jonathan Duncan wrote about Re: Weeding
out duplicates:
>For the info
At 17:25 -0600 on 07/09/2004, Jonathan Duncan wrote about Re: Weeding
out duplicates:
For the information of someone who may need it in the future. I used
Jeffrey's idea for determining duplicates. Then I created a temporary
table, and used insert...select to put the id's of the dup
At 10:25 -0600 on 07/09/2004, Jonathan Duncan wrote about Re: Weeding
out duplicates:
Lachlan,
I want to identify the entries in the table where the email addresses
are the same as another entry. Whatever else is in the record does not
matter to me.
However, a second requirement for the query
and address information
is
the same but email addresses differ?
Lachlan
-Original Message-
From: Jonathan Duncan [mailto:[EMAIL PROTECTED]
Sent: Friday, 9 July 2004 7:54 AM
To: [EMAIL PROTECTED]
Subject: Weeding out duplicates
I am trying to get rid of duplicate user info entrie
July 2004 7:54 AM
To: [EMAIL PROTECTED]
Subject: Weeding out duplicates
I am trying to get rid of duplicate user info entries in a database. I
am assuming that the email address is unique but other information, like
first name, last name, address, etc are not. The "email" field is n
email addresses differ?
Lachlan
-Original Message-
From: Jonathan Duncan [mailto:[EMAIL PROTECTED]
Sent: Friday, 9 July 2004 7:54 AM
To: [EMAIL PROTECTED]
Subject: Weeding out duplicates
I am trying to get rid of duplicate user info entries in a database. I
am assuming that the email ad
Jeffrey,
That actually does a good job, thank you. The reason I am doing this is
so that I can delete the duplicates. However, the query you gave me
shows me the first match of a duplicate. Is there a way to show the
last match of a duplicate instead? I am wanting to save the first
entries but
> I am trying to get rid of duplicate user info entries in a database. I
> am assuming that the email address is unique but other information, like
> first name, last name, address, etc are not. The "email" field is not a
> unique field in the database. I was trying something like the
> follo
I am trying to get rid of duplicate user info entries in a database. I
am assuming that the email address is unique but other information, like
first name, last name, address, etc are not. The "email" field is not a
unique field in the database. I was trying something like the
following, but not
10 matches
Mail list logo
