ACCESS IIF 的用法

在access 用iif 結果會等於sql case

=IIf([行業別]=1,"烘焙業",IIf([行業別]=2,"餐飲業",IIf([行業別]=3,"咖啡廳",IIf([行業別]=4,"個人工作室",IIf([行業別]=5,"機關團體",IIf([行業別]=6,"其他",IIf([行業別]=7,"烘焙材料行",IIf([行業別]=8,"百貨量販業",IIf([行業別]=9,"飯店業")))))))))