Avatar of LZ1
Flag for United States of America

asked on 

Inner join query not returning results using "LIKE" operator

Hey Experts!!
I have a query (below), that I am trying to have return results if the MMColParam (varable) if the variable is somewhere within the number using "LIKE" as the operator.
The query works if I enter the ENTIRE number exactly, however this is not what I need.  

Can someone help??????
SELECT DISTINCT (Client.ACT_no) AS Expr1, *
FROM (((ACT_Master RIGHT JOIN Client ON ACT_Master.ACT_No = Client.ACT_no) 
INNER JOIN AED_master ON Client.ACT_no = AED_master.ACT_No) 
INNER JOIN Models ON AED_master.Model_ID = Models.Model_ID) 
INNER JOIN Cat_Sub ON Client.CatSub_ID = Cat_Sub.CatSub_ID
WHERE (((AED_master.Serial_Code) LIKE [MMColParam]));

Open in new window

Microsoft AccessSQL

Avatar of undefined
Last Comment
Guy Hengel [angelIII / a3]

8/22/2022 - Mon