以文本方式查看主题 - 易表在线答疑 (http://www.egrid2000.com/dvbbs/index.asp) -- 用户社区 (http://www.egrid2000.com/dvbbs/list.asp?boardid=2) ---- 如何统计各科及格人数 (http://www.egrid2000.com/dvbbs/dispbbs.asp?boardid=2&id=29251) |
||||
-- 作者:sdqz6173 -- 发布时间:2017/4/22 20:39:00 -- 如何统计各科及格人数 请问老师:在“”及格“”表中的 “”各科及格“”列中如何统计“”成
绩“”表中某班各科都及格的人数 |
||||
-- 作者:iyplx2425 -- 发布时间:2017/4/23 10:51:00 -- CountFor("成绩","语文", ">" ,59,"数学", ">" ,59,"英语", ">" ,59,"政治" ,">" ,59,"历史", ">" ,59,"地理", ">" ,59,"物理", ">" ,59,"化学", ">" ,59,"生物", ">" ,59,"班级", "=" ,[班级]) |
||||
-- 作者:wjq1072 -- 发布时间:2017/4/23 11:35:00 -- 刷新公式: Eval("Countfor(""成绩"","""+Substitute(Mid(ListCols("成绩"),0,Search("总分",ListCols("成绩"))-1),"|",""","">="",60,""")+""","">="",60,""班级"",""="",[班级])")
|
||||
-- 作者:sdqz6173 -- 发布时间:2017/4/23 11:57:00 -- 谢谢各位老师, |