Forum Discussion

Ganesh99's avatar
Ganesh99
Copper Contributor
Jan 12, 2023
Solved

Switch function in Access is not evaluating more than 2 conditions

Hello All,   Assume a table has columns Description, SO and Region.   Column5: Switch([description]=[SO],"L2L",[region]="Bangalore" Or "ROK","K2L",[region]="East" Or "West" Or "North" Or "South",...
access
  • Karl_Donaubauer's avatar
    Karl_Donaubauer
    Jan 12, 2023

    Hi,

     

    The syntax for the OR operator is wrong. You would have to repeat the full comparison for every value, i.e. [region]="Bangalore" Or [region]="ROK" etc. With more than 1 value it's easier to use the IN operator. If I  understand your intention correctly, then this should work:

     

    Switch([description]=[SO],"L2L",[region] IN ("Bangalore", "ROK"),"K2L",[region] IN ("East", "West","North","South"),"L2L")

     

    Servus
    Karl
    ****************
    Access Bug Trackers
    Access News
    Access DevCon

     

XPS35's avatar
XPS35
Iron Contributor
Jan 12, 2023

Karl
You copied the one of OP's errors. I think it should be:
Switch([description]=[SO],"L2L",[region] IN ("Bangalore", "ROK"),"K2L",[region] IN ("East", "West","North","South"),"O2L")

@Ganesh
I am not sure what you want. If the first condition ([description]=[SO]) is true "L2L" is returned, no matter what region. Is that what you want.

Ganesh99's avatar
Ganesh99
Copper Contributor
Jan 13, 2023
Hi XPS35

I spotted it and used it according to my use case. It worked perfectly. Thanks a ton for being around. It is wonderful that people take these simple challenges too to help others.

Regards
Ganesh

Resources