Below I have how I come up with Q1's total yes responses, but I also need the total no responses for Q1, and the total yes and no responses for the rest of the questions.
SELECT COUNT(Q1)
FROM Responses
WHERE Q1='Yes'
I am just trying to tabulate the total number of Yes and No responses for each question. The table I am getting the responses out of is called "responses" Each question has a Yes or No answer. Questions are Labled as Q1, Q2, Q3 and so on..its pretty simple, I am just not a frequent...
Hi, I am trying to create a survey results display page. I have roughly 20 questions, each with a Yes/No response.
Q1 Yes No
Q2 Yes No
Q3 Yes No
and so on.. any help on how to display the results? Please let me know, Thanks!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.