help in Counting values where greater than 0

[neemi]

I have a report based on a table with a lot of figures.

One of the fields in the table is the price of a car for example. What I need to do is get a count of this. in my report I have a field where I have set it to "=Count([Cost B/F]).

However this gives me the wrong number.

I want to count the records and give me a count where [Cost B/F] is greater than 0.

So in the table if I have 157 records with 120 that are greater than 0 the field in the report should be 120 and not 157 as I am getting.

Can anyone help with a quick easy way of achieving what I want.

Cheers in advance.

Neemi

 

[tledwards]

If you want to still use Count try

=Count(IIf([Cost B/F]>0,1,"&quot).

I don't like to use "", so I usually use

=Sum(IIf([Cost B/F]>0,1,0)).

 

[neemi]

Thanks for your help tledwards!!

I don't know why I didnt think of that myself.

But cheers. Appreciated.

Neemi