G
Guest
I am trying to count and add the occurrences of "No" that occur in selected
table fields for individual records on a form. The expression below is
working for me to some extent, but counts the field values for the entire
database and not for each individual record. How can I correct this
expression to make it work the way I want?
=Sum(IIf([A2]="No",1,0)+IIf([A2a]="No",1,0)+IIf([A7]="No",1,0)
IIf([A7a]="No",1,0) IIf([A8]="No",1,0))
table fields for individual records on a form. The expression below is
working for me to some extent, but counts the field values for the entire
database and not for each individual record. How can I correct this
expression to make it work the way I want?
=Sum(IIf([A2]="No",1,0)+IIf([A2a]="No",1,0)+IIf([A7]="No",1,0)
IIf([A7a]="No",1,0) IIf([A8]="No",1,0))