N
Nick
SELECT ALID0001.label_id, ALID0001.date, ALID0001.time, ALID0001.scans,
ALID0001.Employee_id
FROM ALID0001
WHERE (((ALID0001.label_id) Like "e*" And (ALID0001.label_id) Not In (SELECT
[LABEL_ID] FROM [ALID0001] WHERE [SCANS]<>"07")) AND
((ALID0001.date)=[Forms]![DailyReport]![DataDate]));
This code work well for a single day but I would like it to tell me that
label_id where [scans] = "02" on [DataDate] and did not have [scans] = "02"
or "01" or "08" on the following day
In other words if label_id 12345 has [scans] "07" and "02" on [DataDate] or
09/27/05 and label_id 12345 does not have [scans] of "02" or "01" or "08" on
DataDate 09/28/05
I hope this clear. Thanks
ALID0001.Employee_id
FROM ALID0001
WHERE (((ALID0001.label_id) Like "e*" And (ALID0001.label_id) Not In (SELECT
[LABEL_ID] FROM [ALID0001] WHERE [SCANS]<>"07")) AND
((ALID0001.date)=[Forms]![DailyReport]![DataDate]));
This code work well for a single day but I would like it to tell me that
label_id where [scans] = "02" on [DataDate] and did not have [scans] = "02"
or "01" or "08" on the following day
In other words if label_id 12345 has [scans] "07" and "02" on [DataDate] or
09/27/05 and label_id 12345 does not have [scans] of "02" or "01" or "08" on
DataDate 09/28/05
I hope this clear. Thanks