How do I create an Access 2002 report using only text data from a.

[Guest]

I held an online survey (FrontPage) that dumped the survey data into an
Access 2002 database. I am now trying to create a report that gives me a
break down of the answers to each question. Example: The first question is a
yes/no question and I want it to list the question and then give me a total
(count) the number of yes answers and the number of no answers. So the
question would be listed and then next to it a field that said how many yes
answers and how many no answers. Some questions have more than two options
but again I would like a total for each answer to show on the report. Help
please......

 

[Duane Hookom]

There is a complete survey demo (At Your Survey) at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane that has
such a report.

You might need to normalize your table(s) prior to creating a report like
this.

 

[Guest]

Thank you for the information. What does it mean to "normalize" a table? Is
that the same thing as "Analyzing" the table?

 

[Duane Hookom]

Check some links from
http://www.ltcomputerdesigns.com/JCReferences.html#DatabaseDesign101

--
Duane Hookom
MS Access MVP


"StaceysMOISDTechQuestions"