I am trying to fill a list :
SELECT Seta.Field1, Seta2B.Field7, Seta2B.Field9
FROM Seta INNER JOIN Seta2B ON Seta.ID1 = Seta2B.ID2
WHERE (((Seta.Field1)<>[Forms]![Descriptions4].[Form].[RT].[CAPTION]) AND ((Seta2B.Field7) Like [FORMS]![Descriptions4].[Form].[Lnameb].[caption]))
ORDER BY Seta2B.Field7;
Seta.Field1 is a barcode
Seta.Field7 is a date
I am trying to get the list filled with dates that equal that comming from the source list, but not equal to the barcode number appearing in a label (RT)
Any ideas, thanks
SELECT Seta.Field1, Seta2B.Field7, Seta2B.Field9
FROM Seta INNER JOIN Seta2B ON Seta.ID1 = Seta2B.ID2
WHERE (((Seta.Field1)<>[Forms]![Descriptions4].[Form].[RT].[CAPTION]) AND ((Seta2B.Field7) Like [FORMS]![Descriptions4].[Form].[Lnameb].[caption]))
ORDER BY Seta2B.Field7;
Seta.Field1 is a barcode
Seta.Field7 is a date
I am trying to get the list filled with dates that equal that comming from the source list, but not equal to the barcode number appearing in a label (RT)
Any ideas, thanks