Hello All,
I was recently working on an issue in Excel and discovered that I needed to use Access. Being a complete novice with Access I'm turning to you all for help.
What I have is three tables:
1. Patient
2. Part A - Acute Care
3. Part D - Prescription
The Part D - Prescription includes a date where the prescription is filled by a pharmacy.
The Part A - Acute Care has a date range for when the patient was in a hospital. (Note - there are multiple date ranges for some patients)
I would like to know if the prescription was filled when the patient was in the hospital. Can you all help me write the query?