Help with couting a value

[David]

Hello,

I'm trying to count a text value for a report. In one of the report's
controls I have =Count([PhotoID])="Yes". So I would like to know how many
Yes' there are.

The field is a text field not a Yes/No

Any help would be great.
Thank You
David Ehrenreich

 

[Duane Hookom]

Try:
=Sum(Abs(PhotoID="Yes"))