Counting Records for a Safety Survey

[rsgriffith]

I've distributed a written Safety Survey to 250 employees, the survey is comprised of 28 questions with check-off columns consisting of "Agree", "Disagree", "Strongly Agree", etc.

I've also created a db for it in order to compile the results. I have one table that actually consist of the 28 questions and one table for the multiple responses. To populate the "questions table" I've created a "form" that consists of the 28 items (questions) with a drop-down box which looks at the response table of "Agree", "Disagree", "Strongly Agree", etc. which in turn stores the responses back to the question table.

I currently have a query that looks at the inputted data and then a report looking at the query which is working correctly but the data needs compiling. I'm thinking that this will need to be setup from the query but not sure how to do it. I would like the report to look like the following if at all possible:

Please note that in the preview mode the columns of Agree, Disagree, and Strongly Disagee are not lining up correctly over the response numbers, I had to use underscores to align properly.

_____________________________________Agree__ Disagree__Strongly Disagree
1.) My Employer cares about my safety.____200______25__________25
2.) Production is rated higher than safety___190______10__________50
3.) etc..

Your help greatly appreciated..
RSG

 

[RichO]

It looks like you want a crosstab query/report.

First, create a query with your 2 tables properly linked and all fields selected. We'll call this Query1. Then design a new query using the crosstab query wizard, and select Query1. Use the question field as the row heading and the answer field as the column heading. Choose "Count" from the list of functions.

This should give you what you need.