dolfan1873
Technical User
i am trying to write an if statement that will find different occurances and return a result,
if Item = like "123A*" then
Cat = S
end if.
this works fine but to save alot of typeing or space i want to use the like for more than one instance
if item = like "123A*" or "123AB*" or "123B*" then
cat = S.
this does not work, can i do this or is the format just wrong, and if so can someone help on the format for this.
thanks
if Item = like "123A*" then
Cat = S
end if.
this works fine but to save alot of typeing or space i want to use the like for more than one instance
if item = like "123A*" or "123AB*" or "123B*" then
cat = S.
this does not work, can i do this or is the format just wrong, and if so can someone help on the format for this.
thanks