In Access, we can’t use CASE statement.
Alternatively, we can use Switch statement.
Usage
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.
Readers who viewed this page, also viewed:
Google Drive: Stop Automatic Conversion ” and ‘ to “” and ‘’
Author Profile
LibreOffice: Show Database Data on Spread Sheet- Java: Get Standard Input from System.in without Scanner
Create Wireless Internet Radio with Raspberry Pi (1 of 2)
PostgreSQL: Print Values on the SCREEN- (日本語) Python: スプレッドシートで各要素の掛け合わせの表を作る
目薬に含まれる成分の効果
Think about Euler’s Formula on polyhedron
(日本語) 2019年6月 東京都葛飾区のタバコのルール 条例で定められた禁止事項と罰則