Query to total and count responses, including 0

[macdoggy]

I have a table of 50 different multiple choice answers to about 8 questions. Each question has a set of 5 answers to choose from.

I want to make a query that will count how many of each answer was given for each question. Here is the problem - I want to show the 5 possible answers for each question, even if that answer wasn't chosen.

So, for example question 1 has the possibilities agree,
disagree, neither agree nor disagree, strongly agree or strongly disagree. I want my query to give a percent on each answer and if no one chose that answer, it would give me 0 percent.

I then want to be able to get the same data, but narrowed down by city and state.

My Table structure:

tblQuickAnswer has qaID (autonumber) and QuickAnswer (text) - this is the list of all possible multiple choice answers

tblQuestions has qID (autonumber), qNumber (orders questions), qType (type of answer expected), qText (text of question)

tblQuestionQuickAnswers has qID_FK (qID foreign key from
tblQuestions), and qaID_FK (qaID foreign key) - this links the 2 above tables, giving the possible combinations of question to multiple choice answer.

tblAnswers has qID_FK (qID foreign key from tblQuestions), pID_FK (pID foreign key from tblParticipants), and AnswerText (text of given responses).

tblParticipants has pID (autonumber), State, and City - it is linked to tblAnswers by pID.

Thanks for your help!

 

[MikeC14081972]

How are you linking the possible answers to the questions. I don't see a link to tblQuickAnswer.

Look at Grouping the results of your query to get what you need.