[AccessD] delete duplicates

Hello Gustav,

i have used before and after this message the full syntax. I still had the
error.
After making a new test database everything worked fine.
Mybe something was corrupt. I don't know.

Anyway thanks for the help.

Pedro Janssen



----- Original Message -----
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Thursday, September 11, 2003 12:24 PM
Subject: Re: [AccessD] delete duplicates



> You need to use the full syntax of a "normal" delete query. Something
> like:
>
>   DELETE *
>   FROM test
>   WHERE test.PK Not In (Select FirstOfPK from Query1);
>
> Remember to run this first on some sample data and/or save a decent
> backup of your database!
>
> /gustav
>
> >> Yes, look up the archive on
> >>
> >>   Eliminating duplicate rows
> >>
> >> for June this year.
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>