Sorting options box numbers

[Guest]

I have created a form which is identical to a survey being given to new
graduate nursing students. 25 questions involve clicking on one of four
option buttons within an option group. The four options are strongly
disagree, disagree, agree, and strongly agree. The option group enters a
number 1-4 based on the button selected into the table that this particular
form inputs data into. In other words SD=1, D=2, A=3, and SA=4, and in the
table for that field 1,2,3,or 4 is displayed.
I am now working on a query and was wondering how to count the number of
people who responded either 1, 2, 3, or 4. Any one know a good expresion?

 

[Dale Fye]

Bob,

Are you storing the results in 25 fields? If so, you are going about this
all wrong.

Your response table should be in the form of:
RespondentID, Question_No, Response.

Then, you can do a query that would look something like:

SELECT Question_No, Response, Count(Question_No) as Responses
FROM tbl_Responses
GROUP BY Question_No, Response

This particular query will only get you the questions and responses that
actually have a response (if no one responds SA to a question, then you will
not get a row in the result set for that response.

HTH
Dale

 

[Duane Hookom]

There is a sample with this type of structure at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Dale Fye]

Duane,

I knew I had seen a sample like this somewhere, thought it was Allen Brown's
site, but couldn't find it. Thanks for the reminder.

Dale