|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
求助:TRANSFORMl语句实现各科分数段统计出错
TRANSFORM Count(生物) AS 生物 SELECT 班级 FROM [cj$d1:p800] GROUP BY 班级 PIVOT Switch([生物]>=115 ,"115以上",[生物]>=110 And [生物]<115,"115>X≥110",[生物]>=100 And [生物]<110,"110>X≥100",[生物]>=90 And [生物]<100,"100>X≥90",[生物]>=80 And [生物]<90,"90>X≥80",[生物]>=70 And [生物]<80,"80>X≥70",[生物]>=60 And [生物]<70,"70>X≥60",[生物]>=50 And [生物]<60,"60>X≥50",True,"50以下") In ("115以上",115>X≥110,"110>X≥100","100>X≥90","90>X≥80","80>X≥70","70>X≥60","60>X≥50","50以下")" |
|