M Mechele Registered User. Local time Today, 21:04 Joined Jan 25, 2002 Messages 121 May 23, 2002 #1 I have a Spouse Attending field that is a yes/no field. I do I get my report to only count the "Yes" in the field?
I have a Spouse Attending field that is a yes/no field. I do I get my report to only count the "Yes" in the field?
mdemarte Computer Wizard Local time Today, 21:04 Joined May 8, 2001 Messages 138 May 23, 2002 #2 Create an unbound text field on the report. The control source = Sum(IIf([field1],1,0))
Graham T Registered User. Local time Today, 21:04 Joined Mar 14, 2001 Messages 300 May 23, 2002 #3 Mechele The following should work: =Count(IIf([Spouse Attending]=Yes,1,0)) HTH
Graham T Registered User. Local time Today, 21:04 Joined Mar 14, 2001 Messages 300 May 23, 2002 #4 Sorry, not sure if my above answer works. Below counts check boxes. =Sum(Abs([Spouse Attending])) It's been a long day!
Sorry, not sure if my above answer works. Below counts check boxes. =Sum(Abs([Spouse Attending])) It's been a long day!
