I need to identify in which programs(locations) the Medicine was given.
These are tables/fields I receive from our records system.
My only common field is the TieName and IndividualName but that is a many to many relationship.
tblProgramsbyIndividuals ID (Key) LastName FirstName MiddleName IDNumber IndStatus Program(locations) ProgramType ProgramName EnrollmentDate DischargeDate TieName
tblMARPasses ID (Key) IndividualName AdministeredDate AdministeredTime
Knowing that there are only 2 "ProgramType":
1. Day (Usually occurs Mon-Fri 8a-3p)
2. Residential (all others)
I was able to identify the Program if there is only 1 Day or 1 Residential (or 1 of each) for each individual. My issue is we move people a lot. Using the Enrollment and Discharge Dates, I want to identify when someone moves from 1 Residential home to another sometime during the month...say the 15th.
Can anyone direct me to some examples of querying Data using Dates that is beyond the usual "Between #Date# and #Date#". I really think this is more complicated then what comes up in a general Google search.