Count number of entries with "1"

[Josie]

I need to sumit a report which counts the number of quotes we make a month. I
can easily calculate that. However, I also need to calculate in those quotes
how many came up positive. How can I do that? I have a query which gives me
those, but I don't want to repeat data, can I put a condition on the count?

Thanks if anyone can help

 

[fredg]

I need to sumit a report which counts the number of quotes we make a month. I
can easily calculate that. However, I also need to calculate in those quotes
how many came up positive. How can I do that? I have a query which gives me
those, but I don't want to repeat data, can I put a condition on the count?

Thanks if anyone can help

Your subject line says "entries wuith '1'" and your message bocy says
"came up positive". There is a difference?

Using an unbound control on the report in the report (but NOT in the
Page Footer or Page Header):

If you meant any positive number......
=Sum(IIf([FieldName] >0,1,0))

If you did mean exactly 1...
=Sum(IIf([FieldName] =1,1,0))