This is the Access query. 

 (((dbo_CostCtrGrp.AdmitDate)<#7/1/2007#) AND ((dbo_CostCtrGrp.Expdate) Between #7/1/2007# And #6/30/2008#)) OR (((dbo_CostCtrGrp.AdmitDate)<#7/1/2007#) AND ((dbo_CostCtrGrp.Expdate) Is Null));

 

I've tried a bunch of different ways and nothing works.

 

IsNull({CostCtrGrp.Expdate}) and
{CostCtrGrp.AdmitDate} < Date (2007, 07, 01) or
({CostCtrGrp.AdmitDate} in Date (2007, 07, 01) to Date (2008, 06, 30) )or
(({CostCtrGrp.DischargeDate} in Date (2007, 07, 01) to Date (2008, 06, 30)) and
{CostCtrGrp.AdmitDate} < Date (2007, 07, 01))

 

This is the code that worked.