Count

L

Lou

I am trying to count different types of errors in a Report Footer: Correct,
Discrepancy, Error, Drop. I used the =Count(*) to get the total records, but
need to get a count of them separately.

Thanks.
 
F

fredg

I am trying to count different types of errors in a Report Footer: Correct,
Discrepancy, Error, Drop. I used the =Count(*) to get the total records, but
need to get a count of them separately.

Thanks.
Click to expand...

In unbound text control in the report footer:
=Sum(IIf([SomeField] = "Correct",1,0))
=Sum(IIf([SomeField] = "Discrepancy",1,0))
etc.
 
L

Lou

Thanks very much.

fredg said:
I am trying to count different types of errors in a Report Footer: Correct,
Discrepancy, Error, Drop. I used the =Count(*) to get the total records, but
need to get a count of them separately.

Thanks.
Click to expand...

In unbound text control in the report footer:
=Sum(IIf([SomeField] = "Correct",1,0))
=Sum(IIf([SomeField] = "Discrepancy",1,0))
etc.
Click to expand...
 
Top