Code help

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top