survey results crosstab

[Anth Stever]

I have some survey data in the following format:

QuestionNumber | AnswerValue | Language | SiteName
1 | A | Spanish | Site 1
1 | B | English | Site 2
2 | A | English | Site 1
3 | A | Spanish | Site 2
5 | C | English | Site 2
1 | A | English | Site 1
2 | C | Spanish | Site 1
1 | A | English | Site 2
6 | C | English | Site 1
1 | A | English | Site 2
7 | C | English | Site 1
1 | A | Spanish | Site 2

....and so on (questions 1 through 7); tens of thousands of rows.

I'd like a crosstab with the following output:

| 1 | 2 | 3 | 4 | 5 | 6 | 7 |
A | English | 10| 25| 5 | 7 | 10| 90| 110|
A | Spanish | 14| 25| 5 | 7 | 10| 90| 110|
B | English | 20| 45| 15| 20| 30| 19| 10 |
B | Spanish | 20| 45| 15| 20| 30| 19| 10 |
C | English | 10| 25| 5 | 70| 40| 90| 21 |
C | Spanish | 20| 45| 15| 20| 30| 19| 10 |

Of course, I've made up these numbers (in reality, all the rows with
"English" would add up to the same sum as each other and all the "Spanish"
rows would be equal to each other. My fall back position is to just do two
separate queries for English and Spanish. Can it be done in one?

Thanks!

 

[Duane Hookom]

I'm not sure where the "value" is coming from but it looks like you could
set both the AnswerValue and Language as Row Headings and QuestionNumber as
the Column Heading.