I'm trying to count the number of Yes values in a query. I'm having trouble getting the right answer.
There are 38 records in the query and 11 have a Yes in the ValetSvc field. If I don't add any criteria the result is 38. I need to add criteria that will give me the correct answer of 11
=DCount("[ID1]","[All]",[ValetSvc]='Yes') This formula returns 0
=DCount("[ID1]","[All]","[ValetSvc]='Yes'") This formula returns an error
Any help would be appreciated.