Count if in iif function

[liozzi]

Hello,

i am a novice in ms access so really need help

Wonder if i can have a count if function inside the iif function.

In excel i will create a formula like this =if(countif($a$1:$a$100,a1)=1,a1,""))

Is there anyway that i can create that kind of formula in query criteria?

Thanks in advance.