G
Guest
I have a query that uses the expression below. As it is, it shows active
patients who have an appointment within the date range the user enters, but
drops the patients that don't. I need it to always show ALL the active
patients, but indicate that they have no appointments in the specified date
range. Any suggestions would be appreciated.
HAVING (((PatientDay.Date) Between [Enter begin date:] And [Enter end
date:]) OR ((Patient.DischargeDt) Is Null)) AND (([All Active Home
Care].Team)<>"HOS")
patients who have an appointment within the date range the user enters, but
drops the patients that don't. I need it to always show ALL the active
patients, but indicate that they have no appointments in the specified date
range. Any suggestions would be appreciated.
HAVING (((PatientDay.Date) Between [Enter begin date:] And [Enter end
date:]) OR ((Patient.DischargeDt) Is Null)) AND (([All Active Home
Care].Team)<>"HOS")