随笔分类 -  Access

在Access中实现 case when功能
摘要：在Access无法使用SQL语句中的case when语句，但可以通过Switch函数实现 例如： Switch(成绩<60,"不及格",成绩 Between 61 And 74,"中",成绩 Between 75 And 88,"良",成绩 Between 88 And 100,"优") AS 成... 阅读全文

posted @ 2009-06-03 16:33 步三少 阅读(7519) 评论(1) 推荐(0)