1 access中iif函数中的_在Access查询中使用IIF、Switch、Choose函数

时　间:2014-11-01 12:10:52

作　者:摘　要:在查询中使用VBA内置函数。

正　文:

在Access查询中使用IIF、Switch、Choose函数可以实现不同值的选择：

使用IIF函数：

Select Name AS 姓名, iif([Sex]="1" ,"男" , "女") AS 性别, Class AS 班级, Score AS 成绩

FROM Students

Where Score >= 60;

使用Switch函数：

Select Name AS 姓名, Switch([Sex] = "1","男",[Sex] = "2", "女") AS 性别, Class AS 班级, Score AS 成绩

FROM Students

Where Score >= 60;

使用Choose函数：

Select Name AS 姓名, choose([Sex] ,"男" , "女") AS 性别, Class AS 班级, Score AS 成绩

FROM Students

Where Score >= 60;

Access软件网官方交流QQ群(群号:39785885)

Access源码网店