Calculated Field in a Form-formula problem

[RBoshears]

I have a form with an underlying query. I am attempting to generate several calculated controls based on fields within the query. Most fields contain either a "yes", "no", "pending", or No Resp". I am trying to count each result within a given field. My formula in the control is

=Count(IIF([field name],yes,0)). The result is always the total number of records, not just the ones with a "yes" in them. Help???

 

[bat17]

what is the SQL record source for the List?
I suspect that you have a hidden column and that is what you should be checking against, so that your expresion would need to be something like
=Count(IIF([field name],1,0)).

Depending on the value for "yes"

HTH

Peter

 

[RBoshears]

There is a table that is referenced for the list. the source is the numeric value for ech answer: yes=1, no=2 , pending=3, na=4, no resp=5. I originally had the formula the way you had it, and it gave me the full record count.

 

[bat17]

I think that jobb was on the right track, try
=Sum(IIF([field name]=1,1,0))

Peter