two nested case statement

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

two nested case statement

Post by BittenApple »

Hello team,
I want to write two nested case statements:

case1
field1 > field2 and field2> field3 and field3 >field4 then
case1
case2
case3


case2 field1 < field2 and field2< field3 and field3 <field4 then
case1
case2
case3

What would be the syntax? Or is this doable?

Regards,
Bitten

User avatar
HansV
Administrator
Posts: 78232
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: two nested case statement

Post by HansV »

That is not a Case statement, and they are not nested. Use If ... ElseIf ... Else ... End If:

Code: Select all

    If field1 > field2 And field2 > field3 And field3 > field4 Then
        ...
    ElseIf field1 < field2 And field2 < field3 And field3 < field4 Then
        ...
    Else
        ...
    End If
Best wishes,
Hans

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: two nested case statement

Post by BittenApple »

:clapping: thanks bittenapple