How to count a field if the numbers are <0

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

Guest

I have a field that calculates a number. In the footer I want to count only
the numbers that are less than zero. What expression doI use?
 
Bonnie,
In the query behind the report, add a column like this...
NegCount : IIF(MyCalc < 0, 1, 0)
Then in the appropriate footer...
= Sum(NegCount)
will yield the number of Negative calculations.
hth
Al Camp
 
Bonnie said:
I have a field that calculates a number. In the footer I want to count only
the numbers that are less than zero. What expression doI use?
Click to expand...


Bonnie, Bonnie, Bonnie. You don't really mean to use the
word "field" here do you? If it really is a field in the
report's record source table/query, then you can use a text
box expression like:
=Abs(Sum([field] < 0))

But, you probably meant to use the word "control", in which
case you might be able to use something like:
=Abs(Sum((expressionthatcalculatesthenumber) < 0))

If the calculation is too complex for that, then you need to
use a running sum text box. Add a text box named
txtRunCount to the detail section. Set its expression to
=-(nameofcalculatedcontrol < 0)
and set its RunningSum property to Over All.
Then the footer text box can display the desired count with
=txtRunCount
 
Back
Top