I have a questionaire with 15 questions like this:
DVT Prophy y n n/a
Tubes y n n/a
Where y=1, n=0, n/a=9.
I need a query to use for a report that takes the number of responses that are either 1 or 9 (combined #) and divides by the total number of responses to that question to get a percentage, and this must be by month the questionaire was answered. So in the end...
DVT Prophy Jan 85% Feb 88% Mar 90%
Tubes Jan 77% Feb 87% Mar 88%
and so on.
Can anyone offer any suggestions? I have individual a select querie for the number that answered 1 or 9 and a total query by month for that, as well as one for the total number of people who answered the question per month, but I can't combine them in one query. Thanks.
DVT Prophy y n n/a
Tubes y n n/a
Where y=1, n=0, n/a=9.
I need a query to use for a report that takes the number of responses that are either 1 or 9 (combined #) and divides by the total number of responses to that question to get a percentage, and this must be by month the questionaire was answered. So in the end...
DVT Prophy Jan 85% Feb 88% Mar 90%
Tubes Jan 77% Feb 87% Mar 88%
and so on.
Can anyone offer any suggestions? I have individual a select querie for the number that answered 1 or 9 and a total query by month for that, as well as one for the total number of people who answered the question per month, but I can't combine them in one query. Thanks.
