Count Currency >£0.00

[steve2jh]

I wish to count the number of values on a report where the value is greater
than £0.00 i have tried numerous different ways all to no avail for
EG:=Count(([Rate Card Bonus])>"£0.00") no matter how i write this line i
either get error to complex or a count of all records, help!!!!!!!!!!!!

 

[John Spencer]

Try

= Count(IIF([Rate Card Bonus]>0,1,Null))
COUNT counts the presence of a value. Your test always returns a value of
true or false (-1 or 0)

Alternative solutions:

=Sum(IIF([Rate Card Bonus]>0,1,0))

or

= Abs(Sum([Rate Card Bonus]>0))




--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[steve2jh]

Hi John, Sorry for the delay in the reply. Once again You have come up with
goods, if only we all had your logic and clear thinking what a chilled life
we would all have, many many thanks for your continued help & support in this
forum, regards steve

Try

= Count(IIF([Rate Card Bonus]>0,1,Null))
COUNT counts the presence of a value. Your test always returns a value of
true or false (-1 or 0)

Alternative solutions:

=Sum(IIF([Rate Card Bonus]>0,1,0))

or

= Abs(Sum([Rate Card Bonus]>0))




--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I wish to count the number of values on a report where the value is greater
than £0.00 i have tried numerous different ways all to no avail for
EG:=Count(([Rate Card Bonus])>"£0.00") no matter how i write this line i
either get error to complex or a count of all records, help!!!!!!!!!!!!