newbie in search of help

[m1kegbrown]

I am trying to create a report that looks at users responses to 8 questions, and returns all the users who selected positive answers to 5 or more questions. Each question usually consists of 5-6 answers and usually 2 of those are a positive result. Do I need to make +100 if statements to achieve this result or is there and easier way?

 

[mark curtis]

How do u record a positive result?

You can work out a % based on questions answered positive against questions answered and then set the query to only show results over a certain %.

Post the db for a look?

 

[m1kegbrown]

newbie

right now the result is given from a pull down that selects from very good to very bad.(or as relevant to the question) this answer along with its key are stored in a table that references the usersid and the answer