Crosstab Groupings

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

I would like to create a crosstab query to count IDs by specific ranges:

95% >
75 - 94%
50-74%
<50%

I do not know how to create this grouping by percentage.
 
Also, do you want these groupings as Row Headings or Column Headings?
Can you share anything about your table(s)?

The first thing I would do is to create a buckets table that identifies the
minumum and maximum values for you range "buckets".

tblBuckets
===================
BuckMin BuckMax BuckTitle
0 49 Less Than 50
50 74 From 50 to 74
75 94 From 75 to 94
95 99999 95 and Greater
 
Back
Top