Countif in iif function

[liozzi]

Uups.. i asked in the wrong category. Now move the question to the right one I hope

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 expression builder?

Thanks in advance.

 

[jdraw]

You might get some ideas from reviewing functions at
http://www.techonthenet.com/access/index.php

Access does not have a CountIf function.
You could review DSum function as a start.

Good luck.

 

[Solo712]

Uups.. i asked in the wrong category. Now move the question to the right one I hope

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 expression builder?

Thanks in advance.

Yes. Yu would use a domain aggregate function DCount. The expression would look sth like

=Iif(DCount(....) = 1, ValueOne, "")

Best,
Jiri