MS Access Criteria

Afternoon all - intermediate MS Access skills here needing assistance to streamline a report built on several layered queries.  Ideally some option exists to build advanced criteria - where results account and charges records return only if the ADM_DATE (col G) of the account is within the START_DATE and END_DATE (Cols C and D).  The report is driven by currently by a Between date function on the "Start Date" field.

I report on significant volumes of patient detail for my company, a healthcare provider.  My goal is to limit the criteria to pull charges by patient for a patient-specified date range, which currently I have to accomplish through  running a few reports almost as list feeds which build on one another.  I've dummied up what I'm getting current state and what i hope to get future state.

Does anyone know of a method by which to accomplish this in a single query?

Thanks!

Joe