Hello,
I have created a tracking DB for a clinic. It has four tables, and one of my queries that pulls from two of them is not working properly.
I am trying to pull all actively enrolled clients by the name of their clinician.
The query SQL: SELECT [Youth Contact Info].[Youth Name], [Youth Contact Info].MRN, Enrollment.[Intake Date], Enrollment.[Assigned Clinician]
FROM [Youth Contact Info] LEFT JOIN Enrollment ON [Youth Contact Info].[Youth Name] = Enrollment.[Youth Name]
WHERE (((Enrollment.[Assigned Clinician]) Like [Enter Clinician Name] & "*") AND ((Enrollment.[Enrollment status])="assigned"))
ORDER BY Enrollment.[Assigned Clinician];
When I enter one of the clinician's names, their active clients appear. But, when I enter any of the other clinician names, the query is empty - even though they have active clients assigned.
Any thoughts as to why this query is not pulling the data for the other clinicians?
Thanks