Instr function question
I picked up the below to help me run a query that would allow me to enter more than one value for a parameter.
InStr([Event number separated by commas],[EventNumber]) the query also has a criteria that it should be greater than zero.
When I run this query though, the result is not an exact result. If I enter event 34, I get event 34 as well as 3 and 4.
What is wrong?
I picked up the below to help me run a query that would allow me to enter more than one value for a parameter.
InStr([Event number separated by commas],[EventNumber]) the query also has a criteria that it should be greater than zero.
When I run this query though, the result is not an exact result. If I enter event 34, I get event 34 as well as 3 and 4.
What is wrong?
