With using the following sql statement, is it possible to do more than one field at a time?

SELECT Count(*) AS CountYes
FROM (SELECT tblYesNo.fldYN
FROM tblYesNo
WHERE tblYesNo.fldYN=Yes);

Thanks

Bobby