Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Like but not equal to

Status
Not open for further replies.

Domino2

Technical User
Jun 8, 2008
475
GB
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
 
Very sorry, but the code does work. The control RT was getting its value after the query had fired, doh!! Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top