Code to add Yes and N/A's

[Brian62]

I am trying to add the Yeses and N/A's in a query from my table. I have tried to count, sum and Sum(Abs and I can not get them to add up correctly. All it is doing is adding the total count in the column. I also need to add the No's separately from the others. Thanks!

[TheShabz]

are they a text field? if so, we'll assume the field name is called "reply" and the table is named "myTable"

SELECT Count(myTable.reply)
FROM myTable
WHERE myTable.reply = "yes" OR myTable.reply = "N/A"

for the No you would do:
SELECT Count(myTable.reply)
FROM myTable
WHERE myTable.reply = "no"