Count of If Statement

[nike2000]

Hi there,
I have the following If Statement populating a field on a continuous form:

=IIf([AllChecks]="Yes","Yes","No&quot

I would like to display in the Form Header the number of records that are "Yes".
How can I count the results from this If Statement.
Thanks,
Nike

 

[Trendsetter]

Add an unbound textbox to your header and in the control source type = Count(*)

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[nike2000]

Trendsetter,
Unfortunately that hasn't worked.
Do you have any other suggestions.
Thanks,
Nike

 

[nike2000]

I finally got it to work.
I used the following:

=-sum([Allchecks]="Yes&quot

Thanks for your help.
Nike