在Access查询中使用IIF、Switch、Choose函数

时　间:2014-11-01 12:10:52
作　者:Big Young   ID：252  城市：襄阳
摘　要:在查询中使用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;