Help using AND OR in IIF statement

[oliviar]

Hi Guys,
I want to do this:
iif([POP] = 1 OR 2 OR 3,[POP]+1,[POP])

When I wrote it like that, it just added 1 to everything - even if the POP wasn't 1,2,or 3.

What am I doing wrong?

 

[boblarson]

Another way of writing your incorrect statement is:

x = 5
If Not x = 1 Then
    If 2 Then
        If 3 Then
            x = 5 + 1
        Else
            x
        End If
    End If
End If

Another way of writing the correct statement is:

x = 5
If Not x = 1 Then
    If Not x = 2 Then
        If Not x = 3 Then
            x = 5 + 1
        Else
            x
        End If
    End If
End If

If using VBA then yes, but the other works in a query or control source where this code wouldn't.

 

[oliviar]

I see... because I have not asked the if 2 or if 3 to compare against anything, its just going 2? and 3? and 2 or 3 on their own are just 2 or 3. they can't be false.

 

[boblarson]

I see... because I have not asked the if 2 or if 3 to compare against anything, its just going 2? and 3? and 2 or 3 on their own are just 2 or 3. they can't be false.

Yep, you got it.