G
Guest
If someone can steer me into the right direction on this, you would be
helping me out a lot. Here is my problem…
I have put together this database to record information on two types of
entities – Coordinators and Principle Investigators.
Basically one table holds all the data for both, but here is one question
and answer that is asked and recorded for both.
1. Overall, how would you rate the quality of the assistance the Resource
Center has provided to you and your PBRN? And the user enters in either 1
for Unacceptable, 2 for Fair, 3 for Good, 4 for Very Good, 5 for Excellent or
N/A for Not Applicable.
There are other questions but if I can get help with this one, I can do the
rest on what you help me on.
There are 80 entries for this one question.
To separate the Coordinators from the Principle Investigators, I gave
Coordinators a C and Principle Investigators a PI so that I was able to
create a query.
So I have one query for Coordinators and one query for Principle
Investigators.
Now here is where I run into a problem of not knowing how to do this…
The report that I need built has to show how many people, out of this 80,
selected Unacceptable, selected Fair, selected Good, selected Very Good,
selected Excellent, and selected N/A. I also need to calculate the
percentages for each of these as well.
So question one's reporting information looks like this...
Unacceptable: 19 / 54%
Fair: 3 / 3%
Good: 23 / 24%
and so on. The numbers above are just for show and are not real
calculations. That is just the format that I envision.
How can I do this? I hope that I didn't confuse you all on this. I just
don't know what to do and everytime I ask a question on here, many people are
kind enough to help me and they end up giving great help!
Hope someone can help me out here.
Thanks very much for your help.
helping me out a lot. Here is my problem…
I have put together this database to record information on two types of
entities – Coordinators and Principle Investigators.
Basically one table holds all the data for both, but here is one question
and answer that is asked and recorded for both.
1. Overall, how would you rate the quality of the assistance the Resource
Center has provided to you and your PBRN? And the user enters in either 1
for Unacceptable, 2 for Fair, 3 for Good, 4 for Very Good, 5 for Excellent or
N/A for Not Applicable.
There are other questions but if I can get help with this one, I can do the
rest on what you help me on.
There are 80 entries for this one question.
To separate the Coordinators from the Principle Investigators, I gave
Coordinators a C and Principle Investigators a PI so that I was able to
create a query.
So I have one query for Coordinators and one query for Principle
Investigators.
Now here is where I run into a problem of not knowing how to do this…
The report that I need built has to show how many people, out of this 80,
selected Unacceptable, selected Fair, selected Good, selected Very Good,
selected Excellent, and selected N/A. I also need to calculate the
percentages for each of these as well.
So question one's reporting information looks like this...
Unacceptable: 19 / 54%
Fair: 3 / 3%
Good: 23 / 24%
and so on. The numbers above are just for show and are not real
calculations. That is just the format that I envision.
How can I do this? I hope that I didn't confuse you all on this. I just
don't know what to do and everytime I ask a question on here, many people are
kind enough to help me and they end up giving great help!
Hope someone can help me out here.
Thanks very much for your help.