Search results

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...

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...

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...

Hey Guys, I am really needing some help with this. I have a patient table which has fields PatientID and ProviderID, so I can produce a query that shows me how many patients each provider has; however, I need a report (query) that can show me what perecnt of a provider's patient have for...

That helped a ton!! Thanks. I actually added a medical condition name to the query so that I could see the actual conditions along with count. Thanks again! God bless.

Here is a copy of my dummy DB Bob. Thanks.

Where can I email it? Thanks. I have created the file.

Sorry Bob, correction I only get results if I do not include medical condition name at all. I have attached a screenshot of the patientconditions table, the medical conditions table, and the results i get when not including medical condition name in the query.

Hello Bob, I have attached screen shots of what I have in which I get no results when trying to add the med condition name. I get results with a count when I de-select the med condition name. Thanks for your help on this.

First off, Thanks for all of your help Bob. Ok, I have created the patientconditions table and I created a query of lastname, firstname, dob, and medicalconditionID. I did a group by on all and a count on the medicalconditionID of >1. The query worked but it just shows a number. I was able to...

Thanks again, I am using Iron Speed. It takes the database and coverts it to a web app. This one may take me some time as everything you said looks like foreign language as of now. But I am going to read up on it. Thanks again.

So Bob, after all of that, the application building tool that I am using, doesn't support multi-value fields. Any idea how I woud go about obtaining this information with an alternative route? Any help would be greatly appreciated.

Bob, thanks that worked!! I also listed them by name by grouping by expression.. thanks so much!! have a great day sir...

cool.. getitng there, so how do i place a count on medicalcondition which is how i figured i would have to do it, but no clue on how...

definitely helps so far... I actually don't have a VisitID field.. should I? My fields are as follows PatientID LastName FirstName DOB PhysicianID InsuranceID MedicalCondition (Lookup Table Field) I apologize for sounding stupid in the first place but how do I do a grouping of them and a count...

Thanks Bob, I actually read that several times and it it show how to create a query that will show all patients, but I want a report that specifically shows all patients that have more than once a greater than 1 selected value. Been stumped for 2 days now. Thanks for the reply.

I am new to building a database, but I have created a multi-vaule field for patient conditions in which any number of the conditions can be chosen in the field (1-8) as there are 8 conditions and any combination. I want to create a query that will show me the patients that have more than one...