Count records excluding zero

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

Guest

Hi
How to count the number of records that are having value >0 in a report, i
have tried the following

=Count([field]>0) , it is always giving me all the records.. please advise
 
Hi
How to count the number of records that are having value >0 in a report, i
have tried the following

=Count([field]>0) , it is always giving me all the records.. please advise
Click to expand...

=Sum(IIf([FieldName]>0,1,0)
 
Back
Top