Have results from survey display in report

[icsupt via AccessMonster.com]

I have a survey that had 38 questions that had multiple choices. I imported
the reponses to the survey into my Access database. To count up how many
people answered a certain way on the report, I mimicked the survey by putting
the questions on the left hand side of the page and then I put the choices as
column headings. The choices that were available for each question was
"Always", "Sometimes", "Never". A sample of my formula that I used in my
column headings was "=Sum(IIf([9a]="Always",1,0))" which gave me the count of
how many people responded "Always". This is working fine. However, this did
cause the "too many fields defined" message. I fixed this problem by
dividing the report up as a subreport. This also worked fine.

Now here's my problem.

There are four open ended questions (#15-18) that I now need to capture on
one page. So for instance, on the surveys for John Smith, 25 people answered
the open ended questions. I want to have on page 2 of my report all of the
responses for the questions all grouped together. So I need all of responses
for question #15 to stay together. Then all of the responses for question
#16 would come next and would also stay together and so on.

Please let me know if you need any additional information. I'm desperate and
have spent many hours trying to figure this out.

Thanks so much. This website is wonderful.

 

[Duane Hookom]

You could first normalize your table with a union query. Then a solution
similar to "At Your Survey
at http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane might
be possible.

 

[icsupt via AccessMonster.com]

When I click on that link, I get to a PKZIP page, but nothing happens. I try
and download into a folder and still nothing happens. Am I doing something
wrong.

 

[Duane Hookom]

I don't know what you might be doing wrong. I just clicked on the download
and was prompted to save or run the file.

 

[icsupt via AccessMonster.com]

I wanted to post how I did a workaround for my problem. I have four free
form questions that I wanted to appear on one page. So I made four columns
with one question in each column. Not the prettiest, but it sure did the job.


Thanks to all who responded.