count records

[nat35]

Hi there
I need to be able to count how many records have a value and have many haven't
example job_No Value
1 $50
2 $0
3 $10
with value = 2 without = 1

Any one have any ideas
thank you

 

[Reebo99]

Create 2 formulas :

{@HasValue}
If {Value} > 0 then 1 else 0

{HasNoValue}
If {Value} = 0 then 1 else 0


Then place these in the detail, right click on the fields, insert, summary and sum the fields.

You can now delete the fields from the detail.

Hope this helps.

Reebo
Scotland (Sunny with a Smile)

 

[nat35]

Thank you for that
While I was waiting for reply
I worked out how to do it. and it is the same way!!!
Nat