I have a patient registry database in which I am developing EBC Score Reports. They are basically based on percentages. I have a patient table and a providers table. I have created a query PatientCountByProvider that shows me how many patients each provider has. What I want is to create a query that take certain percentages. For example. I have a Condition Met query that shows me all of the patients that meet a certain criteria. What I want to know is how many patients of each provider's total are on it. SO say Provider 1 has 100 patients which I found from my patientcount query.. and has 20 patients on the condition query, how do I create a query that gives me that 20/100 so show the percentage. Any help would be GREATLY appreciated. I'm losr in the water here... Thanks
EBC Score Reports
- Thread starter mabrown81
- Start date
- Local time
- Today, 03:16
- Joined
- Jan 23, 2006
- Messages
- 15,576
Please show us a jpg of your tables and relationships. Also, the SQL for your queries would be helpful.
We have no idea what an EBC score is.
Can you tell us in plain English exactly what you are trying to accomplish?
I think this is a general formula for percentage you require
(NumberOfPatientsByProvider/TotalNumberOfPatients) * 100 = PercentageOfPatientsByProvider
We have no idea what an EBC score is.
Can you tell us in plain English exactly what you are trying to accomplish?
I think this is a general formula for percentage you require
(NumberOfPatientsByProvider/TotalNumberOfPatients) * 100 = PercentageOfPatientsByProvider
Here are the jpegs, but I just want to know the formula for calculating percentage that you stated. My two quries procude the numbers that I want. I just want to calculate those numbers and haven't been able to do so. How do I take one query divided by another. When I do that, the numbers came out wrong, so I know it's in the query design. Thanks for even taking the time out to assist me.
Attachments
Update: EBC Score Reports
I got the patientcount/totalpatientcount formula to work, now my only issue is this: I want multiple columns with percentages but I know that queries are sort of a process of elmination, so when if a certain provider doesnt meet the criteria for all columns included then they are left off. Is there any way I can simply list ALL my providers and then show the percentages for the ones that it applies to? For example, say I have Prov1 who has 3/6 patients who are asthma so thats 50% and Prov2 has no asthma patients but has 1/4 on diabetes patients which 25%. If i choose both of these in the query, i will come back with nothing.
I got the patientcount/totalpatientcount formula to work, now my only issue is this: I want multiple columns with percentages but I know that queries are sort of a process of elmination, so when if a certain provider doesnt meet the criteria for all columns included then they are left off. Is there any way I can simply list ALL my providers and then show the percentages for the ones that it applies to? For example, say I have Prov1 who has 3/6 patients who are asthma so thats 50% and Prov2 has no asthma patients but has 1/4 on diabetes patients which 25%. If i choose both of these in the query, i will come back with nothing.
