Crosstab Groupings

[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.

 

[KARL DEWEY]

Post the SQL of your crosstab.

 

[Duane Hookom]

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