My if then else logic is unwieldy 2

[elpico]

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.

 

[Remou]

Hi
How about the other way round?
if queueid = 57 or queueid = 83 or queueid = 84 then
do other stuff
else
do stuff
end if

 

[HarleyQuinn]

Why doesn't it work?? What happens when you run it??

Harleyquinn

---------------------------------
For tsunami relief donations

 

[elpico]

Hmmm, I feel stupid now - Thanks for that!

 

[PHV]

Try this:
If queueid <> 57 And queueid <> 83 And queueid <> 84 Then
do stuff
Else
do other stuff
End If

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244