Hi

I found this formula in the forum to remove duplicates :

for i in select Table_Name.Email_field do

while cnt(select Table_Name where Email_field = text(i))!=1 do

delete last(select Table_Name where Email_field = text(i))

end

end

 (The example is "email")

I tried it but it does not work.

I wonder where is the mistake :

 -Is that the beginning of the formula "for i in select" ?

-Should "Table_name" by instance be "table_ Albums" ?

-Should "Email_field" by instance be "Colonne1_field" ?

Thanks for the help.