用数据透视表如何分析各班各分数层的人数，好心人帮帮忙了

应该是说总分在410以下，410以上，420以上，430以上，440以上，450以上，460以上，470以上，480以上，490以上，500以上，510以上，520以上，530以上，540以上，560以上，570以上，580以上，590以上，600以上分数层的各班人数各是多少，用数据透视表来分析！谢谢

等于分界线的分数归属？比如某学生刚好410分，归哪

我搞了一个，你看看行不行，不含分界线上的分数

SQL：select "<410",班别,sum(iif(总分<410,1,0)) as 人数 from [Sheet1$] group by 班别 union all select ">410",班别,sum(iif(总分>410,1,0)) as 人数 from [Sheet1$] group by 班别 union all select ">420",班别,sum(iif(总分>420,1,0)) as 人数 from [Sheet1$] group by 班别 union all select ">430",班别,sum(iif(总分>430,1,0)) as 人数 from [Sheet1$] group by 班别 union all select ">440",班别,sum(iif(总分>440,1,0)) as 人数 from [Sheet1$] group by 班别 union all select ">450",班别,sum(iif(总分>450,1,0)) as 人数 from [Sheet1$] group by 班别 union all select ">460",班别,sum(iif(总分>460,1,0)) as 人数 from [Sheet1$] group by 班别 union all select ">470",班别,sum(iif(总分>470,1,0)) as 人数 from [Sheet1$] group by 班别 union all select ">480",班别,sum(iif(总分>480,1,0)) as 人数 from [Sheet1$] group by 班别 union all select ">490",班别,sum(iif(总分>490,1,0)) as 人数 from [Sheet1$] group by 班别 union all select ">500",班别,sum(iif(总分>500,1,0)) as 人数 from [Sheet1$] group by 班别 union all select ">510",班别,sum(iif(总分>510,1,0)) as 人数 from [Sheet1$] group by 班别 union all select ">520",班别,sum(iif(总分>520,1,0)) as 人数 from [Sheet1$] group by 班别 union all select ">530",班别,sum(iif(总分>530,1,0)) as 人数 from [Sheet1$] group by 班别 union all select ">540",班别,sum(iif(总分>540,1,0)) as 人数 from [Sheet1$] group by 班别 union all select ">550",班别,sum(iif(总分>550,1,0)) as 人数 from [Sheet1$] group by 班别 union all select ">560",班别,sum(iif(总分>560,1,0)) as 人数 from [Sheet1$] group by 班别 union all select ">570",班别,sum(iif(总分>570,1,0)) as 人数 from [Sheet1$] group by 班别 union all select ">580",班别,sum(iif(总分>580,1,0)) as 人数 from [Sheet1$] group by 班别 union all select ">590",班别,sum(iif(总分>590,1,0)) as 人数 from [Sheet1$] group by 班别 union all select ">600",班别,sum(iif(总分>600,1,0)) as 人数 from [Sheet1$] group by 班别


另外，你这个分级，比如410分以上，与420分以上，两个，前者包不包含后者（理论上，410分以上包含420分以上，如果不包含就要特别说明）

[ 本帖最后由 handsomcao 于 2011-8-10 20:05 编辑 ]

这样行不行：  

Book1.rar (135.81 KB)

先用函数分了等级，这样子？

Book1.rar (155.86 KB)

好像有 问题，等着看别人的吧………………

[ 本帖最后由 琴琴1122 于 2011-8-10 20:08 编辑 ]

我搞了一个，附件看2楼，你条件没说清，SQL可以实现，你看了之后，提出要求，我修改