Counting fields

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

Guest

I am trying to create a formula to count the number of records that show a
comp ratio of greater than 80%. Comp ratio is a field name and show a result
of two fields already thru a query. This is what I have in the control
source field=Count([Comp Ratio]>80).
Please Help!!!!! :(
 
Charlotte said:
I am trying to create a formula to count the number of records that show a
comp ratio of greater than 80%. Comp ratio is a field name and show a result
of two fields already thru a query. This is what I have in the control
source field=Count([Comp Ratio]>80).
Click to expand...


COunt counts any value that is not Null, so your expression
counts every record. Try this:

=ABS(SUM([Comp Ratio]>80))

which works because True is -1 and False is 0
 
Back
Top