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
fredg - 30 May 2005 17:16 GMT
> an example:
>
[quoted text clipped - 13 lines]
>
> thanks in advance
=sum(IIf([PaymentAgreed]=-1 AND [Paid]=-1,1,0))

Signature
Fred
Please only reply to this newsgroup.
I do not reply to personal email.