Count of records IF...

[Nathan]

I have a form that contains records about each file.

In the form header, I have an unbound field that counts the total number of
records. It works fine.

What I want is ANOTHER field in the form header that also gives me a count
of all the records, but only if a certain checkbox on the form is checked
(and by extension, that particular field in the record is -1).

I'm sure this is panfully easy to do, but its escaping me right now.

 

[Ofer Cohen]

Create a text box in the Form Header and in it control source write

=Sum(IIf([YesNoFieldName]=True,1,0))

 

[Nathan]

Perfect, thanks!

Create a text box in the Form Header and in it control source write

=Sum(IIf([YesNoFieldName]=True,1,0))

--
Good Luck
BS"D

I have a form that contains records about each file.

In the form header, I have an unbound field that counts the total number of
records. It works fine.

What I want is ANOTHER field in the form header that also gives me a count
of all the records, but only if a certain checkbox on the form is checked
(and by extension, that particular field in the record is -1).

I'm sure this is panfully easy to do, but its escaping me right now.