G
Guest
I am not sure if what I am about to ask is the best way to do something or
not but here goes...
I have a database with survey answers for 22 different questions. Each
question was multiple choice with answers ranging from 1 to 5 (there are a
few 0s where the question was not answered because it did not apply). I need
to produce a report that summarizes the answers for review.
The report needs to show the number of responses for each choice for each
question (how many people answered 1 for question one, how many people
answered 2 for question 1 and so on). I also need to know the % that each of
these represents.
My problem is I don't know how to code a function that will allow me to run
a SQL statement (i.e. SELECT COUNT(SurveyID) blah, blah, blah. Can any great
minds out there give me a quick example on how this is done in a module that
I can call from a report?
not but here goes...
I have a database with survey answers for 22 different questions. Each
question was multiple choice with answers ranging from 1 to 5 (there are a
few 0s where the question was not answered because it did not apply). I need
to produce a report that summarizes the answers for review.
The report needs to show the number of responses for each choice for each
question (how many people answered 1 for question one, how many people
answered 2 for question 1 and so on). I also need to know the % that each of
these represents.
My problem is I don't know how to code a function that will allow me to run
a SQL statement (i.e. SELECT COUNT(SurveyID) blah, blah, blah. Can any great
minds out there give me a quick example on how this is done in a module that
I can call from a report?