网友
温暖的阳光的问题:
求学生每科成绩的前20%转化为A,前50%转化为B,前80%转化为C,后20%转化为D,自定义函数如何写,谢谢
http://www.accessoft.com/bbs/showtopic.asp?id=18779
Select 成绩.姓名, 成绩.语文, DCount("姓名","成绩","[语文]>" & [语文] & "")+1 AS 语文成绩排名, (DCount("姓名","成绩","[语
文]>" & [语文] & "")+1)/(DCount("姓名","成绩","[语文]")) AS 语文成绩排名百分比位置, 成绩.语文等级, Switch([语文成绩排名百分
比位置]<=0.2,'A',[语文成绩排名百分比位置]<=0.5,'B',[语文成绩排名百分比位置]<=0.8,'C',[语文成绩排名百分比位置]>0.8,'d') AS 语
文成绩等级, 成绩.数学, DCount("姓名","成绩","[数学]>" & [数学] & "")+1 AS 数学成绩排名, (DCount("姓名","成绩","[数学]>" & [数
学] & "")+1)/(DCount("姓名","成绩","[数学]")) AS 数学成绩排名百分比位置, 成绩.数学等级, Switch([数学成绩排名百分比位置]
<=0.2,'A',[数学成绩排名百分比位置]<=0.5,'B',[数学成绩排名百分比位置]<=0.8,'C',[数学成绩排名百分比位置]>0.8,'d') AS 数学成绩
等级
FROM 成绩;
点击下载此附件