Omitting certain values from query results

[tim1234]

I have a database that tracks customer survey responses. All questions are rated on a 1 (worst) to 5 (best) scale. The problem that I have is that my report keeps the neutral (3) responses and uses them to perform it's calculations.

For example:
If I have 25 returned surveys each having answered 9 questions with a numerical response (1-5). If 10 people put a neutral (3) answer because the question doesn't apply to them, I want to be able to base my average off of the remaining 15 peoples responses. In other words I don't care if they have a neutral opinion, I only want to calculate the average using the negative (1,2) or the positive (4,5) responses. I need to still use their other responses to the other questions as long as they are not the number 3.

Any help would be greatly appreciated.

 

[The_Doc_Man]

When you do your count queries, you have two choices. Either count the 3's and realize they are valid responses - or specify selection criteria to toss out the 3's. To me, the mid-point answer is possibly valid. (I'm reminded of an old cartoon about a guy taking a survey and an irate person telling him, "make sure you mark that one as Don't Care rather than Don't Know.")

If you want to take aggregate queries of fields EXCEPT the ones that have a 3, make a secondary query (unfortunately, for each question) that selects all responses not equal to 3. Then do your aggregate of the query, not the raw table.

 

[tim1234]

Thanks, I'll try that.