R
RJB
I *think* this is an Access question. Been about ten years since I've
actually had to use Access myself, but I think I've landed in the right spot.
Received a report from Excel, a survey. Sixteen respondents, each row of the
report is one answer to one question from one respondent. In other words:
RESP | TOPIC | QUESTION | RESPONSE
=================================
Adam | Envir. | Quest. 1 | 4
Adam | Envir. | Quest. 2 | 3
Adam | Mt'ls. | Quest. 3 | 4
Adam | Mt'ls. | Quest. 4 | 4
Brian | Envir. | Quest. 1 | 5
Brian | Envir. | Quest. 2 | 4
Brian | Mt'ls. | Quest. 3 | 4
Brian | Mt'ls. | Quest. 4 | 3
.... and so on, to respondent 'n'.
I'd like a report that reads as follows:
ENVIR.
Quest. 1
A | 4
B | 5
....
n | 4
====
Avg. 4.3
Quest. 2
A | 3
B | 4
....
n | 4
===
Avg. 3.67
MAT'LS.
Quest. 3
etc. etc. etc.
I would have thought putting the survey into two Queries and linking might
work, but as it's organized in rows, I'm a wee bit lost.
I have over 500 lines of data, so if I can AVOID grinding it out by hand,
I'd LIKE to.
Thanks, folks!
rjb
actually had to use Access myself, but I think I've landed in the right spot.
Received a report from Excel, a survey. Sixteen respondents, each row of the
report is one answer to one question from one respondent. In other words:
RESP | TOPIC | QUESTION | RESPONSE
=================================
Adam | Envir. | Quest. 1 | 4
Adam | Envir. | Quest. 2 | 3
Adam | Mt'ls. | Quest. 3 | 4
Adam | Mt'ls. | Quest. 4 | 4
Brian | Envir. | Quest. 1 | 5
Brian | Envir. | Quest. 2 | 4
Brian | Mt'ls. | Quest. 3 | 4
Brian | Mt'ls. | Quest. 4 | 3
.... and so on, to respondent 'n'.
I'd like a report that reads as follows:
ENVIR.
Quest. 1
A | 4
B | 5
....
n | 4
====
Avg. 4.3
Quest. 2
A | 3
B | 4
....
n | 4
===
Avg. 3.67
MAT'LS.
Quest. 3
etc. etc. etc.
I would have thought putting the survey into two Queries and linking might
work, but as it's organized in rows, I'm a wee bit lost.
I have over 500 lines of data, so if I can AVOID grinding it out by hand,
I'd LIKE to.
Thanks, folks!
rjb