<[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
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 duplicates in the
temporary table. Then it was a simple "delete from table where
temp.id=table.id".
T
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 is that it show me the last
duplicate instead of the first. This way I keep the first e
Jonathan,
I'm not exactly sure what you want to do..
Do you want to identify the entries in the table where the email addresses
are the same as another entry but the name and address details differ...
or.. do you want to find entries where the name and address information is
the same but email a
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
