Really simple Question.

[Graham Mattingley]

I think I have lost my brain, or drank too much Redbull, because I cant make
the following work.
if menu_list <> "age" OR menu_list <> "first_name" then
....
else
.......
end if

If I do this below, it works.

if menu_list <> "age" then
....
else
.......
end if

How do I this with more than one option, is it with ELSE IF ??

Kind Regards

Graham Mattingley

[Tom B]

You'll never get to your else, because it will always match your expression
Example1: menu_list ="age" --- it doesn't equal "first_name" so it'll do
what's in the if
Example2: menu_list="first_name" --- it doesn't equal "age" so it'll do
what's in the if
Example3: menu_list="BOB" --- it doesn't equal either, so it'll do what's in
the if.

I assume you want to use an AND

if menu_list <> "age" AND menu_list<>"first_name" then
'Example 3 would end up here
else
'Example 1 and 2 would end up here
end if
OR

if menu_list="age" OR menu_list="first_name" then
'Example 1 and 2 would end up here
else
'Example 3 would end up here
end if

"Graham Mattingley" <gr****@technocom.com> wrote in message
news:bj*******************@news.demon.co.uk...

I think I have lost my brain, or drank too much Redbull, because I cant make the following work.
if menu_list <> "age" OR menu_list <> "first_name" then
...
else
......
end if

If I do this below, it works.

if menu_list <> "age" then
...
else
......
end if

How do I this with more than one option, is it with ELSE IF ??

Kind Regards

Graham Mattingley

[Graham Mattingley]

Thanks Tom,

I knew it would be simpleish, think I have been at the screen to long today
:-)

it is all working now :-)

Graham Mattingley

"Tom B" <sh*****@hotmail.com> wrote in message
news:#1**************@TK2MSFTNGP11.phx.gbl...

You'll never get to your else, because it will always match your expression Example1: menu_list ="age" --- it doesn't equal "first_name" so it'll do
what's in the if
Example2: menu_list="first_name" --- it doesn't equal "age" so it'll do
what's in the if
Example3: menu_list="BOB" --- it doesn't equal either, so it'll do what's in the if.

I assume you want to use an AND

if menu_list <> "age" AND menu_list<>"first_name" then
'Example 3 would end up here
else
'Example 1 and 2 would end up here
end if
OR

if menu_list="age" OR menu_list="first_name" then
'Example 1 and 2 would end up here
else
'Example 3 would end up here
end if

"Graham Mattingley" <gr****@technocom.com> wrote in message
news:bj*******************@news.demon.co.uk...

I think I have lost my brain, or drank too much Redbull, because I cant

make

the following work.
if menu_list <> "age" OR menu_list <> "first_name" then
...
else
......
end if

If I do this below, it works.

if menu_list <> "age" then
...
else
......
end if

How do I this with more than one option, is it with ELSE IF ??

Kind Regards

Graham Mattingley