Survey stats in CrossTab

[5lights]

I can do a crosstab that gives count of each ans' for each question. However I need to give the counts per employee, who is a multiple-answer for Question 1.
So a response could have two or more employees listed.
Response table-ie:

RespondentID QuestionID AnswerID AnswerText
3 1 7 Smith, Sam
3 1 6 Jones, John
3 2 1 (Not Answered)
3 3 20 Facility1
3 4 1 (Not Answered)
3 5 23 Good
3 6 28 Poor
3 7 33 Good
3 8 38 Good
etc
Suggestions?

 

[synapsevampire]

Maybe, perhaps you can rephrase this (read your post, "who is a multiple-answer for Question 1" doesn't make sense to me.

And try to remain consistent with references, a "So a response could have two or more employees listed" is confusing as you have a respondent ID and an answer, I'm guessing that you mean a Answer could have 2 or more.

-k

 

[5lights]

Sorry, youre right: "Who" & "Employee" refer to 'AnswerText' for QuestionID '1' in the example table.

Re-phrased...Question '1' can have more than one Answer(Employee), & that field is what I need to report the stats on. So a single Respondent can answer the Questions once & have the Answers apply to more than one Employee.

Hope this helps clarify....I appreciate the quick response