Counting the number of YES's

[diazr]

Can someone give me a hand with the function Dcount for a report the I need to total the number of "YES" for a field called [FORM104]. The QUERY name that its feeding the data from is called -> Weekly Report Filter and the query is using Table: Clients.

 

[khawar]

This should do it

Dcount("FieldName","TableName","FieldName=-1")