Search results

Hello! Have you had a chance to work on the database? I recognize that you are busy. Thank you so much for your help so far, you have helped me out a lot.

That worked! Great! Thank you so much!

I'm sorry, I thought I covered all the bases for the report. :banghead: For DaysDelay, I need it to calculate a total percent for each hospital for: number of people who returned to hospital in less than 30 days. The way I'm doing it now is returning data for each person who went to each...

Hello! I'm working on a query with two different types of dates: entry date and exit date. I want to create a report for people who have both entered and exited our facility. I'm trying to build a query which will exclude all information that does not have any data entered for exit data. How...

I further realized another issue. I am needing percentages of people who returned to the hospital for the same/different admission... under 30 days. I am able to turn out percentages in the reports for all people, not those under 30 days specifically. Is there a way to do that, other than put...

Thanks for letting me know how to do that! I was able to successfully build a report that could tell me how many people (just count, no names) from a hospital returned to the hospital due to same/different admission, and the percentages! I'm having difficulty with DayDelay however. I want the...

Thank you so much! I'm working on the "actual" database now, and I'm using the one that you have graciously built for me as a reference on how to build mine. If possible, could you explain to me how you calculated this percentage...

I'm sorry, I didn't mean to damage the query. I wanted to try to change it myself so I wouldn't have to ask you anymore. :) You have done so much in helping me, I wanted to try to help myself where I could. My facility needs to have the report not show the ones that are more than 30 days. I'm...

THANK YOU SO MUCH!! I'm sure it's less than 30 days. Is there a way to have the report not show the ones over 30 days, yet include it into the percentage reporting? In query, I put <30 in the criteria for Days Delay, but I'm not sure how to correct the percentage on the report. In query, I...

No more. :)

For the Hospital Transfer report, the only information that I did not add/tell you about was the number of people who transferred to our facility from hospital x. I know how to do this. This is the only thing I need to add. After speaking with my supervisor, it appears we only track the first...

I've attached the database with the date updates. In SameDiagnosis and DifferentDiagnosis, I've added the <30 days. DDQ and SDQ does a count for each hospital and diagnosis, and in HospitalR, I have it broken down like so. The thing I can't figure out is the percents!

@_@ Okay. I need an all hospital report. For each hospital, I need a count of how many people who came to our facility returned to the hospital with the same diagnosis. Same for the number of people who returned to the hospital with a different diagnosis. Then, I need a percentage of the...

Oh goodness. Mihail, I just realized that I need the percentages per hospital. I'm sorry, I thought this was all figured out. Is there a way to do that? Should I just move the percentages up to Detail on Report? They also need to be on the same report.. Would I be able to create a new report...

Wow, that's great! THANK YOU SO VERY MUCH! I've been wracking my brains out for the last couple of weeks trying to figure out how to do this! I really appreciate the help. Now I can go off and finish this project. You're so awesome. Thank you again.

This is quite lovely, and I appreciate how you edited my database. I need to figure out how to count the differences and the number of sames, and take percentages next. :'( I tried figuring it out from the above posted suggestions, but I don't think those suggestions work with the edited database.

Does that go into a query? And if so, for the report I have in my database, if I keep the subform under "Detail" will it help produce the results I want? Thanks so much for your help so far.

Here's the converted version.

This is the database that I'm practicing on. To keep it simple, I eliminated things in the Hospital Data that are irrelevant, such as "FacilityAdmitDate" and "HospitalAdmitDate." Additionally, for patient data, I only included name. The "complete" database will include more information.

I changed the formula for the percentages. Additionally, I changed the columns to do the lookup on other tables like you suggested. Thank you! How do I get Access to report the same/different diagnosis per hospital? Meaning, several hospitals listed with the breakdown for each hospital...