An easy(?) "count" question

[ramsayaj]

Hi there,

I am trying to get a report to display the number of records with a text value of "No" in a certain field. I have not used a "yes/no" field, just a text field with a choice of "yes" or "no". I tried using the formula: "=Count([Component ready?]=No)" but it returns the total number of records, not those with a "no" value. Can anyone tell me what I am doing wrong, and give me the right formula?

Many thanks,
Alan

 

[jfgambit]

Assuming you have a footer for the Yes/No field you can add the following to a textbox:

=DCOUNT("[NameofYesNoField]","TableName","[NameofYesNoField] = No")

HTH