I have a query in which I have many text fields that contain yes/no. This is the only way I could get the yes/no out of excel. I want to be able to count these fields getting the count of yes only answers. I have tried adding different criteria and none of it seems to work. Any help would be appreciated. Thanks

Bobby