Count records w/ value greater than "X"

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

Guest

In a report, is it possible to use the count function to count records w/ a value of greater than "X" only....For example, count records w/ a returned value of 20 or greater? Thanks for any help.....
 
On Mon, 9 Feb 2004 12:21:10 -0800, Steve S wrote:

In a report, is it possible to use the count function to count records
w/ a value of greater than "X" only....For example, count records w/ a
returned value of 20 or greater? Thanks for any help.....

Steve,
In an unbound control in that Report section: =Sum(IIf([SomeField]
 
Steve said:
In a report, is it possible to use the count function to count records w/ a value of greater than "X" only....For example, count records w/ a returned value of 20 or greater? Thanks for any help.....
Click to expand...


Several ways. You can use any of these as the control
source expression in a text box:

=Count(IIf(somefield > Xvalue, 1, Null)
or
=Sum(IIf(somefield > Xvalue, 1, 0)
or
=Abs(Sum(somefield > Xvalue))

Just make sure the text box is in a group/report
header/footer section. not a page header/footer.
 
Back
Top