Kevin,
Try this. For the first field put expression
IIF(val<=59,1,0)
and select SUM for this field. Make similar changes to the second field.
>I am trying to do a count in the calculations section in a group footer. I am using an expression for two different text boxes. I want one to count to number of times the field value is less than or equal to 59 and the other to count the number of times the field is greater than 59. For example if there is a total of 26 in the group and say 6 are greater than 59 and the other 20 are less than or equal to 59 it always says 26 as the count on both ignoring the condition in the expression. How do I get it to are compare to the expression and show 20 in one and 6 in the other instead of 26 (the total count) in both regardless?
>
>Kev
--sb--