Count number of entries with "1"

  • Thread starter Thread starter Josie
  • Start date Start date
J

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
 
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
Click to expand...

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))
 
Back
Top