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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
if it is null how not to get the #error 1
Counting only records that have values > 1 4
counting records 0
Count Records in Report 2
Countif, index and match 2
Count Function (conditional counts) in Reports 3
Skip printing selected records 1

Back
Top