Removing Duplicate Data Problem..!

[En]

Any ideas what to do for the best?

I have a table that records some transaction data. Each entry in the table
has an auto gen primary key / ID.

Somewhere along the way there are 1000's of duplicate transactions been
entered, however they are unique because they have different primary key /
ID.

Does anyone know the best way to remove the duplicates from the table but
leaving one copy of the transaction in the table???

I tried a simple delete find duplicate query that found all the duplicates
including the original transaction. I cant afford to delete the original
transaction though.

Any suggestions welcome.

Ian

[Danny J. Lesandrini]

Re: Removing Duplicate Data Problem..!

Take a look at this article ...

http://www.databasejournal.com/features/msaccess/article.php/3077791

--

Danny J. Lesandrini
dlesandrini@hot mail.com

http://amazecreations.com/datafast

"En" <ian@ihankinson .freeserve.co.u k> wrote ...[color=blue]
> Any ideas what to do for the best?
>
> I have a table that records some transaction data. Each entry in the table
> has an auto gen primary key / ID.
>
> Somewhere along the way there are 1000's of duplicate transactions been
> entered, however they are unique because they have different primary key /
> ID.
>
> Does anyone know the best way to remove the duplicates from the table but
> leaving one copy of the transaction in the table???
>
> I tried a simple delete find duplicate query that found all the duplicates
> including the original transaction. I cant afford to delete the original
> transaction though.
>
> Any suggestions welcome.
>
> Ian
>
>[/color]

[En]

Re: Removing Duplicate Data Problem..!

That looks excellent, thankyou.

Ian


"Danny J. Lesandrini" <dlesandrini@ho tmail.com> wrote in message
news:btc7bs$5i8 1i$1@ID-82595.news.uni-berlin.de...[color=blue]
> Take a look at this article ...
>
> http://www.databasejournal.com/featu...le.php/3077791
> --
>
> Danny J. Lesandrini
> dlesandrini@hot mail.com
> http://amazecreations.com/datafast
>
>
> "En" <ian@ihankinson .freeserve.co.u k> wrote ...[color=green]
> > Any ideas what to do for the best?
> >
> > I have a table that records some transaction data. Each entry in the[/color][/color]
table[color=blue][color=green]
> > has an auto gen primary key / ID.
> >
> > Somewhere along the way there are 1000's of duplicate transactions been
> > entered, however they are unique because they have different primary key[/color][/color]
/[color=blue][color=green]
> > ID.
> >
> > Does anyone know the best way to remove the duplicates from the table[/color][/color]
but[color=blue][color=green]
> > leaving one copy of the transaction in the table???
> >
> > I tried a simple delete find duplicate query that found all the[/color][/color]
duplicates[color=blue][color=green]
> > including the original transaction. I cant afford to delete the original
> > transaction though.
> >
> > Any suggestions welcome.
> >
> > Ian
> >
> >[/color]
>
>[/color]