I tend to muck about with VBA (probably more that I should), but that is a carryover from dBase III procedural programming.
I came up with a query that calculates the number of points in each range.
comments?
Code:
SELECT Sum(P1.P20) AS SumOfP20, Sum(P1.P30) AS SumOfP30, Sum(P1.P40) AS SumOfP40, Sum(P1.P50) AS SumOfP50, Sum(P1.P60) AS SumOfP60, Sum(P1.P70) AS SumOfP70, Sum(P1.P80) AS SumOfP80, Sum(P1.P90) AS SumOfP90, Sum(P1.P100) AS SumOfP100
FROM (SELECT PUPoints.Points, IIf([Points]<30,1,0) AS P20, IIf([Points]>=30 And [Points]<40,1,0) AS P30, IIf([Points]>=40 And [Points]<50,1,0) AS P40, IIf([Points]>=50 And [Points]<60,1,0) AS P50, IIf([Points]>=60 And [Points]<70,1,0) AS P60, IIf([Points]>=70 And [Points]<80,1,0) AS P70, IIf([Points]>=80 And [Points]<90,1,0) AS P80, IIf([Points]>=90 And [Points]<100,1,0) AS P90, IIf([Points]=100,1,0) AS P100
FROM PUPoints) AS P1;
(Still working on learning advanced SQL/query creation)