I think I get it.

What I want is to display words displayed only one time in a list

If I use a script a script to find the duplicates it will show the words that have been entered more than one time but it will not work for words entered only one time.

So I should use an other function.

But wich one ?

Thanks

Hi Fred.

I have 2 of them :

1)

let myV := Ordre;

if cnt(select 'Ajouts familles-Tableau 1'where Ordre = myV) > 1 then

"Duplicate"

else

 

null

end

 

2)

let myV := Ordre;

if cnt(select 'Ajouts familles-Tableau 1'where Ordre = myV) > 1 then

"Duplicate"

else

 

"no duplicate"

end

I tried this script :

 

let myV := Ordre;

if cnt(select 'Oiseaux famille genres espéces' where Ordre = myV)=1then

"Duplicate"

else

 

I get this error :

"A table has not been found Oiseaux famille genres espéces on the line 2, column 52"

Hi Fred,

 

I have not found why this script has this error…very strange.

 

So I tried the modification with another base

Always curious,  but better…

-With "> 1" in the script  I got 16 names alone.

-With "= 1" in the script  this time I get 29 names alone.

It's better but why 40 is not found ?

Thanks Fred.

Would it be possible to send you my database ?