时 间: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源码网店