Count of If Statement

[nike2000]

I have a field in a Continuous Form that is populated by the following If Statement:

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

The Field format is a Yes/No Checkbox.
At the top of the form can I have a count of all those records that are 'Yes'?
The Form works off a Query, and no fields are updated in a Table.
If so, how do I go about it?
Thanks,
Nike

 

[jrbarnett]

Create a control with DataSource:
=DCount ("*", "QueryName", "MigrationTeamOK=Yes&quot
replacing QueryName with the name of your query.

John

 

[nike2000]

Thanks for getting back to me but unfortunately it hasn't worked. I have also added the query name.
Do you have any other suggestions?
Nike

 

[PWise]

what type of field is MigrationTeamOk

 

[nike2000]

it is a 'Yes/No' format field.
Nike

 

[PWise]

try
DCount ("*", "QueryName", "MigrationTeamOK=true&quot