View Single Post
  #1  
Old April 26th, 2008, 09:29 PM posted to microsoft.public.access.forms
[email protected]
external usenet poster
 
Posts: 96
Default 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