S
Splinty
I have been wracking my brain trying to figure this out all day. One of my
coworkers came to me with a problem. She needed statistical analysis from
database that contains survey responses. I didn't set up the database, so
have to work with what I have.
Basically I need to obtain the percentages and counts of the responses,
which there are questions that the respondent picked from a list and some
yes/no ones.
In the data portion of text boxes I was thinking that using something along
the lines of the count function like this:
count([main table]![question1answers]![answer1] = "peas") which I got to
work but it doesn't just take the "peas" answers, it counted all of them. Am
I barking up the totally wrong tree on that?
I also tried using a query to sort for the "peas" responses but I can't seem
to reference more than one query as well as the main table in my one report.
Also, my thinking is that all of these computed reponses have to go in the
report header since I have to use the detail to list the fill in responses
for everything.
Help!
If this is impossible please tell me ASAP so I can shake my fist at that
co-worker.
coworkers came to me with a problem. She needed statistical analysis from
database that contains survey responses. I didn't set up the database, so
have to work with what I have.
Basically I need to obtain the percentages and counts of the responses,
which there are questions that the respondent picked from a list and some
yes/no ones.
In the data portion of text boxes I was thinking that using something along
the lines of the count function like this:
count([main table]![question1answers]![answer1] = "peas") which I got to
work but it doesn't just take the "peas" answers, it counted all of them. Am
I barking up the totally wrong tree on that?
I also tried using a query to sort for the "peas" responses but I can't seem
to reference more than one query as well as the main table in my one report.
Also, my thinking is that all of these computed reponses have to go in the
report header since I have to use the detail to list the fill in responses
for everything.
Help!
If this is impossible please tell me ASAP so I can shake my fist at that
co-worker.