Creating reports from survey data

Question

I haven't worked with CF in a long time and was never more
than a beginner. 
I have been given a task and need some help.

I set up a survey form where survey takers respond to several
questions by 
selecting 'strongly disagree', 'disagree', 'neutral',
'agree', or 'strongly 
agree'. I've have the survey page and database set up and the
data is being 
inserted into the database correctly. Now I need to output a
report that 
shows how many responded with each choice for each question.
Is there an 
optimal way to query the database for this information?

Thanks

Newsgroup_User · Answer

Thanks for the quick reply. I am using mySQL. I probably didn't use the best
structure for my table. Each survey participant's responses are inserted as
a record in the table. There is a field for each question's response. The
values are inserted as an integer ( 1 -5, depending on the response).

"Azadi" <azadi@sabai-dee.com> wrote in message
news:furl21$6f$1@forums.macromedia.com...
> what's your db and what is your table structure?
>
> Azadi Saryev
> Sabai-dee.com
> http://www.sabai-dee.com/

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded