Date Query on two date fields in the same query

[jennwilson]

I am trying to generate a report based on a query that will list any records where an individual has a date listed that matches the specified time for one or both of the date fields. The two fields are danpdate and testdate.

  SELECT PatientDemo.PatientType, PatientDemo.ClinicianName, PatientDemo.ClientName, PatientDemo.DOB, PatientDemo.FacilityName, PatientDemo.PrimaryInsurance, PatientDemo.SecondaryInsurance, PatientDemo.TertiaryInsurance, PatientDemo.DANPDate, PatientDemo.IntakeStaff, PatientDemo.TestDate, PatientDemo.TestStaff, [danpdate] & [testdate] AS Expr1, PatientDemo.[Report Received], PatientDemo.Testhours, PatientDemo.ServiceLocation
FROM PatientDemo
WHERE ((([danpdate] & [testdate])>=[Forms]![Report Date Range]![Beginning Date] And ([danpdate] & [testdate])<=[forms]![Report Date Range]![Ending Date]))
ORDER BY PatientDemo.PatientType, PatientDemo.ClientName;

Any guidance you may be able to offer would be great. Currently, my work around is to run two seperate reports based on two seperate queries. 1 query to filter the danpdate and the other query to filter based on the testdate. I am hoping to have the two items merged together to generate one larger report intead of two. Thanks so much.

[kepston]

WHERE ([danpdate] Between [Forms]![Report Date Range]![Beginning Date] And [forms]![Report Date Range]![Ending Date])
Or ([testdate] Between [Forms]![Report Date Range]![Beginning Date] And [forms]![Report Date Range]![Ending Date])
 

This will give you the rows where either danpdate or testdate fall in your range
I hope that is what you were asking for.

[jennwilson]

WHERE ([danpdate] Between [Forms]![Report Date Range]![Beginning Date] And [forms]![Report Date Range]![Ending Date])
Or ([testdate] Between [Forms]![Report Date Range]![Beginning Date] And [forms]![Report Date Range]![Ending Date])
 

This will give you the rows where either danpdate or testdate fall in your range
I hope that is what you were asking for.

THANKS so much. This is the first time I have had a chance to get back online after my original post. The fix worked great. Thanks!