Expression Building

  • Thread starter Thread starter Kim Kowalski
  • Start date Start date
K

Kim Kowalski

Hi! Here's is my problem: I have a field with that will
contain one of three responses. Yes, No and Pending. At
the end of the report I create from this table, I want to
show the total #'s of Yesses, Nos and Pending. I am
stumped regarding creating the correct expression to do
this. Please help!
 
Hi! Here's is my problem: I have a field with that will
contain one of three responses. Yes, No and Pending. At
the end of the report I create from this table, I want to
show the total #'s of Yesses, Nos and Pending. I am
stumped regarding creating the correct expression to do
this. Please help!
Click to expand...

In the Report Footer (not the Page Footer) add an unbound control for
each of the possible responses.
As the ControlSource of one, write:

=Sum(IIf([FieldName]="Yes",1,0)

Do the same in each of the other controls, changing just the criteria
value.

The above assumes that the value in [FieldName] is a Text not a Number
value.
 
Back
Top