Count - if statement....
Hi,
I created a box called TXT_Completed for me to put ="Completed: " &
Sum(IIf([Answer] like "1",1,0)) & " of " & Count (*)
and it works.
I have four groups and I want to set like below and I'm not able to
make it work.
="Completed: IIf([GroupA] like "1",1,0)) & " of " & Count (*)
and
next one,
="Completed: IIf([GroupB] like "1",1,0)) & " of " & Count (*)
I'm struggling last two A and B. Your help would be much
appreciated. I don't know if I do the right thing.
Thanks
|