How to write the query depends on how your tables are set up! That's why Duane kept asking you about it. As database professionals we are going to assume that your tables are normalized and you have something like:
tblQuestions
QuestionID
Question
tblAnswers
AnswerID
Answer
tblSurveys
SurveyID
SurveyDate
tblSurveyAnswers
SurveyID
QuestionID
AnswerID
With data that looks like:
tblQuestion
ID Question
1 Do you like fish?
2 Do you like beef?
3 Do you like cheese?
tblAnswer
ID Answer
1 Yes
2 No
tblSurvey
ID Date
1 9/26/2003
tblSurveyAnswers
SurveyID QuestionID AnswerID
1 1 2
1 2 1
1 2 1
Now if your tables are set up like this then this may work to get the information you want:
SELECT COUNT(IIF(ANSWERID = 1, 1, 0) AS YES, COUNT(IIF(ANSWERID = 2, 1, 0) AS NO FROM TBLSURVEYANSWERS GROUP BY QUESTIONID
Now if your tables are set up differently, you can share your design and we'll see if we can come up with a different solution.
Leslie