Access reports, combine data from 2 queries
Posted on 2011-10-10
This sounds simple, but I have struggled with this for days now. The answer I want is the % of times a caregiver gives a drug and is overriding getting a second signature. I have one query that can get the caregiver, location, date and and drugs that NEED to have signatures. I get the total of needed signatures by caregiver by location on a report. I have another query that I can get caregiver, location, date and and drugs that were given WITHOUT second signature (overridden). Sub-report can get these totals. But how do I connect the caregiver and location on one report with the other so that I can divide the overridden signatures/ number of drugs needing signature * 100 to get % Overridden?
I want it to look something like this:
Location Nurse Overrides Total Drugs-Need 2nd Sign %Override
Nurse Jill 3 9 33%
Nurse Tom 5 10 50%
Office B Nurse Bill 0 10 0%
Nurse Mary 2 8 25%
Total 10 37 27%
On top of this, this whole thing is a sub-report on another report. Any help would be appreciated since I have worked many hrs on this and do not have much to show my employer.