Only Null

[Dan @BCBS]

I need to limit this output to only records without a close date (TR_CLOSEDATE)
Any suggestions???

SELECT tblTrackingData.TR_GRIEVANCECOORDINATOR, tblTrackingData.ICNNO,
tblTrackingData.TR_GBU, tblTrackingData.TR_DATE_TIMERCVD_HOI,
DateDiff("d",[TR_Date_TIMERCVD_HOI],Date()) AS Days,
tblTrackingData.TR_CLOSEDATE
FROM tblTrackingData
WHERE (((tblTrackingData.TR_DATE_TIMERCVD_HOI) Between
[forms]![frmreports].[txtstartdate] And [forms]![frmreports].[txtenddate]));

 

[Ofer Cohen]

Under the TR_CLOSEDATE field write the criteria

Is Null

SELECT tblTrackingData.TR_GRIEVANCECOORDINATOR, tblTrackingData.ICNNO,
tblTrackingData.TR_GBU, tblTrackingData.TR_DATE_TIMERCVD_HOI,
DateDiff("d",[TR_Date_TIMERCVD_HOI],Date()) AS Days,
tblTrackingData.TR_CLOSEDATE
FROM tblTrackingData
WHERE TR_CLOSEDATE Is Null And tblTrackingData.TR_DATE_TIMERCVD_HOI Between
[forms]![frmreports].[txtstartdate] And [forms]![frmreports].[txtenddate]

 

[Dan @BCBS]

Thank you

Under the TR_CLOSEDATE field write the criteria

Is Null

SELECT tblTrackingData.TR_GRIEVANCECOORDINATOR, tblTrackingData.ICNNO,
tblTrackingData.TR_GBU, tblTrackingData.TR_DATE_TIMERCVD_HOI,
DateDiff("d",[TR_Date_TIMERCVD_HOI],Date()) AS Days,
tblTrackingData.TR_CLOSEDATE
FROM tblTrackingData
WHERE TR_CLOSEDATE Is Null And tblTrackingData.TR_DATE_TIMERCVD_HOI Between
[forms]![frmreports].[txtstartdate] And [forms]![frmreports].[txtenddate]
--
Good Luck
BS"D

I need to limit this output to only records without a close date (TR_CLOSEDATE)
Any suggestions???

SELECT tblTrackingData.TR_GRIEVANCECOORDINATOR, tblTrackingData.ICNNO,
tblTrackingData.TR_GBU, tblTrackingData.TR_DATE_TIMERCVD_HOI,
DateDiff("d",[TR_Date_TIMERCVD_HOI],Date()) AS Days,
tblTrackingData.TR_CLOSEDATE
FROM tblTrackingData
WHERE (((tblTrackingData.TR_DATE_TIMERCVD_HOI) Between
[forms]![frmreports].[txtstartdate] And [forms]![frmreports].[txtenddate]));