Your reference to a "Question_ID" field suggests that you actually have more tables, such as a table of questions that you link to the responses table. Is that the case?
Do you have responses in the form of one response to one question per response record or do you have multiple response fields in a single record such that you have one response record for each person responding to your survey?
Thank PhilMod for replying.
My data has been collected using Google forms and is currently in a spreadsheet, one response record for each person responding. Some other forum posts I've been studying have indicated I would be better off with one response to one question with a field to identify the question number and the course it belongs to. I can easily transpose the rows and columns in Excel to import the data in this form if need be. I'm trying to set up a two or three record template that does what I need first, before rearranging and importing data.
I tried making a third table with 9 records: Question_ID, SA, A, D, SD, SA-count, A_count, D_count, SD_count. But that doesn't seem to do what I want either. I feel I might be on the wrong track altogether. I've attached an image of the relationship graph.
Using a data model where each response to a question is a separate record will make counting different responses to each question much easier to set up. You may have seen this thread already, but I'd set up a questionaire DB to follow the tables/relationships shown here: Need aid on generating a report from a survey layout.
With one record to each question response, you can set up a summary report that groups records first by Question ID and then by the specific response. Summary fields can count the records and by putting them in sub summary layout parts, one summary field can count each different response to each different question.
Here's a tutorial on summary reports that may provide you with some ideas: Creating Filemaker Pro summary reports--Tutorial
Thank you PhilMod. I'll read through the above links and try again.