Search results

Hi CJ, I had a chance to input the code and check the restuls and I think it works. Thanks so much for all the help. I will let you know if I find any errors.

Here's another example: Patient ID Intubation Count StartDateandTime EndDateandTime Length of Intubation 1 5 12/4/2009 20:20 12/5/2009 20:10 0.993055556 1 5 12/5/2009 20:15 12/9/2009 10:00 3.572916667 1 5 12/5/2009 8:15 12/30/2009 10:00 20.07291667 1 5 12/30/2009 17:00 1/21/2010 18:00...

Edit2: Ok so after examining the data this is what I've determined: It's actually not the count of intubation that is the problem (i.e. it's happening with intubation counts of 3 or more). What seems to be the issue is the intubations which go beyond 28 days. Here is a made up example of what...

Hi CJ, Thank you for the code. I attempted it this morning but am getting a compile error Here is the code that was input SELECT DISTINCT MultipleIntubations.EpisodeID, (SELECT count(*) from MultipleIntubations as tmp where patientid=MultipleIntubations.EpisodeID) AS CountofStartDate...

Hi CJ, 1. Count of intubations is the number of rows the patient has it is the number of times that each patient was intubated. 2. They are not, I must have done that by accident when I formatted the cell. We use the AM/PM 3. Difference is the number of days that the patient is intubated for...

Hi! Sorry for the delayed response. I actually figured out the multiple intubations thing. It was a combination of me misunderstanding it a bit and learning some excel programming on my own, but we figured it out! Regarding Ventilator Free days that's where I'm still having a bit of a problem...

Hi David and CJ, Thanks for the quick responses! David, I'm not sure I understand yourq eustion. To keep us as accurate as possible my mentor does want us to include all the partial days. It's just that according to medical practice (apparently) an intubation of less than 24 hours doesn't count...

Hi everyone, I'm a new user to this forum and to access. I'm doing a summer research project for medical school and my mentor has given me a task which seem like it could be easy to automate in Access, but unfortunately I have no idea how to do it. We're looking at patients who are intubated...