Can anyone Help....
I have this code running which works fine....except that it returns values like 33, 34, 63.
I would like it to find an exact match IE: "3"
SELECT [New Discplinary Cases].[DAN No], [New Discplinary Cases].LNAME, [New Discplinary Cases].FNAME, [New Discplinary Cases].[Pass No], [New Discplinary Cases].[Violation Number 1], [New Discplinary Cases].[Violation Number 2], [New Discplinary Cases].[Violation Number 3]
FROM [New Discplinary Cases]
WHERE (([New Discplinary Cases].[Violation Number 1]) & ([New Discplinary Cases].[Violation Number 2]) & ([New Discplinary Cases].[Violation Number 3])) LIKE "*" & 3 & "*"
I have this code running which works fine....except that it returns values like 33, 34, 63.
I would like it to find an exact match IE: "3"
SELECT [New Discplinary Cases].[DAN No], [New Discplinary Cases].LNAME, [New Discplinary Cases].FNAME, [New Discplinary Cases].[Pass No], [New Discplinary Cases].[Violation Number 1], [New Discplinary Cases].[Violation Number 2], [New Discplinary Cases].[Violation Number 3]
FROM [New Discplinary Cases]
WHERE (([New Discplinary Cases].[Violation Number 1]) & ([New Discplinary Cases].[Violation Number 2]) & ([New Discplinary Cases].[Violation Number 3])) LIKE "*" & 3 & "*"