Experts:
I a beginner in access. I need some help creating a Query to filter the right City.
Background:
Attached is a sample database table and the query results i am getting.
I am trying to query the number of encounters for each site based on the effective date(service date). I have a startdate and enddate enrollment date. I am trying to create a query where i say if my effective date is in between start date and end date pick the matching clinic. But sometime my effective date is before my start date for eg: For MID "***********7500” my effective date is 4/29/19 in this case i want it to pick "*****_HEMET". Can you Please assist me how to handle this.