[AccessD] delete duplicates

pedro at plex.nl pedro at plex.nl
Thu Sep 11 12:06:25 CDT 2003


Hello Gustav,

Thanks for the answer. 
But when i use your expression i get an erro that i can't seem to solve.
What am i doing wrong.

Pedro

DELETE [test.FieldA]
    FROM test
    WHERE Not In (Select FirstOfPK from Query1);




> Hi Pedro
>
> Yes, look up the archive on
>
>   Eliminating duplicate rows
>
> for June this year.
>
> /gustav



More information about the AccessD mailing list