Good afternoon,
I have a table that I am running a query on. in the query Design across the different columns I have different "filters" I am adding.... However it seems like Access is only running one "filter"....I copied my SQL code below. In my results I am not seeing the Office Name being filtered out nor the Enrollment end date only showing blank values. But it is filtering out the Programs to only show the correct programs..... What am I doing wrong?
SELECT [Case Management Report].[Office Name], [Case Management Report].[Program Enrollment TP Last Updated By], [Case Management Report].[Program Enrollment TP Recorded on Behalf Of], [Case Management Report].[Unique Program Enrollment ID], [Case Management Report].[Case Number], [Case Management Report].[Seeker Name], [Case Management Report].[Program of Enrollment], [Case Management Report].[Enrollment Start Date], [Case Management Report].[Enrollment End Date], [Case Management Report].[Last Completed Staff assisted service PE], [Case Management Report].[Last Completed Staff Assisted Date PE], [Case Management Report].[Last Completed Service Linked to this Program Enrollment], [Case Management Report].[Days Since Last Completed Service Linked to this Program Enrollm], [Case Management Report].[Most Recent Active Duration Service Start Date Linked to this Pr], [Case Management Report].[Most recent Active Duration Service Linked to this Program Enrol], [Case Management Report].[Last Completed Service Date linked to Any Program Enrollment], [Case Management Report].[Last Completed Service linked to Any Program Enrollment], [Case Management Report].[Days Since Last Completed Service linked to any Program Enrollme], [Case Management Report].[Most Recent Active Duration Service Start Date linked to any Pro], [Case Management Report].[Most Recent Active Duration Service linked to any Program Enroll], [Case Management Report].ID, [Case Management Report].*
FROM [Case Management Report]
WHERE ((([Case Management Report].[Office Name])="San Juan Career Center") AND (([Case Management Report].[Program of Enrollment])="WIOA Adult") AND (([Case Management Report].[Enrollment End Date]) Is Null)) OR ((([Case Management Report].[Program of Enrollment])="WIOA Out of School Youth")) OR ((([Case Management Report].[Program of Enrollment])="WIOA Dislocated Worker")) OR ((([Case Management Report].[Program of Enrollment])="WIOA In School Youth")) OR ((([Case Management Report].[Program of Enrollment])="WIA Out of School Youth"))
ORDER BY [Case Management Report].[Days Since Last Completed Service Linked to this Program Enrollm] DESC;