G
Guest
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]));
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]));