Counting with 2 Conditions

[TomP]

I created a report and would like to get a count of records with two
conditions. Here is what I entered:

=Abs(Sum(IIf([terminate]=-1,1,0)) And [caseload]="SA")

This information is entered in an unbound text.

I would like to get a total count where the terminate field (yes/not) is
checked and the caseload meets a certain criteria.

Thank you!

 

[Marshall Barton]

I created a report and would like to get a count of records with two
conditions. Here is what I entered:

=Abs(Sum(IIf([terminate]=-1,1,0)) And [caseload]="SA")

This information is entered in an unbound text.

I would like to get a total count where the terminate field (yes/not) is
checked and the caseload meets a certain criteria.

=Sum(IIf([terminate]=-1 And [caseload]="SA",1,0))
or
=Abs(Sum([terminate]=-1 And [caseload]="SA"))

 

[TomP]

That worked! Thank you so much for your help and patience! Happy New Year!

I created a report and would like to get a count of records with two
conditions. Here is what I entered:

=Abs(Sum(IIf([terminate]=-1,1,0)) And [caseload]="SA")

This information is entered in an unbound text.

I would like to get a total count where the terminate field (yes/not) is
checked and the caseload meets a certain criteria.

=Sum(IIf([terminate]=-1 And [caseload]="SA",1,0))
or
=Abs(Sum([terminate]=-1 And [caseload]="SA"))