Creating reports from survey data

[Newsgroup_User]

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]

what's your db and what is your table structure?

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

[Newsgroup_User]

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/