Count if PaymentAgreed=Yes AND Paid=No

  • Thread starter Thread starter john williams via AccessMonster.com
  • Start date Start date
J

john williams via AccessMonster.com

an example:

Payment Agreed Paid

Yes Yes
Yes No
No No
Yes Yes
No No

(the fields are Yes/No fields, which are all checkboxes)

There are two records here that both have apayment agreed and are not paid.

how do i make a count formula to have it print "2"?

thanks in advance
 
an example:

Payment Agreed Paid

Yes Yes
Yes No
No No
Yes Yes
No No

(the fields are Yes/No fields, which are all checkboxes)

There are two records here that both have apayment agreed and are not paid.

how do i make a count formula to have it print "2"?

thanks in advance
Click to expand...

=sum(IIf([PaymentAgreed]=-1 AND [Paid]=-1,1,0))
 
Back
Top