Hi all,
I haven't been able to find out how to improve this, but basically I've got my if statement, of which there are over 100 types, but I want to access a condition for everything but 2 or 3 things...
ie
if queueid <> 57 or queueid <> 83 or queueid <> 84 then
do stuff
else
do other stuff
This doesn't seem to work - any idea if you can have logic like this (ie, I don't want to have nested queries)
I've tried it with a Select Case statement, but that doesn't seem to work either.
Any help much appreciated.
Cheers,
e.
I haven't been able to find out how to improve this, but basically I've got my if statement, of which there are over 100 types, but I want to access a condition for everything but 2 or 3 things...
ie
if queueid <> 57 or queueid <> 83 or queueid <> 84 then
do stuff
else
do other stuff
This doesn't seem to work - any idea if you can have logic like this (ie, I don't want to have nested queries)
I've tried it with a Select Case statement, but that doesn't seem to work either.
Any help much appreciated.
Cheers,
e.