I have a single table of responses from people. I know their age band, their gender and the responses to a load of questions (answer to each question is in its own field).
Hence:
Name Zel
Age 16-20 (done in about 5 bands)
Gender Male
Qu1 Definitely
Qu2 $10
Qu3 something else
Answer to each question is about 5 different choices (all text). Got lots of questions. Got 35,000 respondents so I don't want to do anything like dropping it to Excel!!!
Want to create reports showing summary of each question broken down by age and gender and also totals. Guess it is a sub query but I am not sure how to start it.
Can't work out how to do it - can anyone help?
Hence:
Name Zel
Age 16-20 (done in about 5 bands)
Gender Male
Qu1 Definitely
Qu2 $10
Qu3 something else
Answer to each question is about 5 different choices (all text). Got lots of questions. Got 35,000 respondents so I don't want to do anything like dropping it to Excel!!!
Want to create reports showing summary of each question broken down by age and gender and also totals. Guess it is a sub query but I am not sure how to start it.
Can't work out how to do it - can anyone help?
