Count

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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