Counting a report field withing a conditional expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to count a yes/no report field when it is true only, but I need to
display the field regardless of its value and it needs to do this within a
conditional expression. I gave it a shot with:

=("# of Units Attended = " & IIf([Attended]=True,Count([Attended]),"None"))
but that doesn't seem to be working for me. Can anyone help me with what
I've missed?
 
Create another field in the section where the True/False field, in the
ControlSource Property write =IIf([FieldName]=True,1,0) and in the RunningSum
Property select
Over All.
===================================
Now the last display of this field will display the count of true
If you want to display this value in the footer of the report then write in
the ControlSource Property of the field in the footer
=[FieldNameYouCreated]
 
Back
Top