Case Statement in Access SQL

In Access, we can’t use CASE statement.

Alternatively, we can use Switch statement.


The above code was written with Switch as follows.

It was said that Access employs Switch because of compatibility with VBA, but I don’t know actual reason.

Use iif

You can also use Iif. The following code leads same result.

Use Choose

It is a choice to use Choose, in some cases.

index に整数を入れると、index = 1 なら a が、 index = 2 なら b が返ります。 整数でない場合は、一番近い整数に丸められます。 If index is less than 1, Null is returned.