Control Source Expression in Form

[laman]

I can't seem to figure this one out. Seems simple but I have tried everything. On a form I am using the contoll source expression =Count([cl]) which returns the total number of records for that field. I would like the result to be the the number of occurances of "nd" in that field.
=Count([cl]= "nd&quot? Does not work.

Please Help
Thanks

 

[jhall156]

Try using DCount() JHall