Originally Posted by
Sa'El
WHERE (((qry_main_4_CurrReadmission.ReadmitDate) Between [Forms]![_ReportGenerator]![StarteDate] And [Forms]![_ReportGenerator]![EndDate]) AND ((qry_main_4_CurrReadmission.IndexStay_ID) Is Not Null));
Give explicit data types to:
[Forms]![_ReportGenerator]![StarteDate]
and
[Forms]![_ReportGenerator]![EndDate]
by defining them as query parameters with a data type that aligns to your ReadmitDate (hopefully datetime).
I've had all kinds of issues with Textboxes not converting to datetime datatypes. The engine tries to figure it out, but fails, a lot.
Cheers,
Jeff