Access 2007 Grouping question
Posted on 2011-03-25
I am working on creating a repot. I need to add grouping to the report. I know how to group on a field where ther are like terms... ie group on city name..
but... here is my question that I need help on..
I need to add grouping based on a value of a field.....
Each record has a rating number... 1 - 60...
I need to group.. ratings 44-60 togther
35 to 44 together
27 to 34 together
15 to 26 togther
0 to 14 togther
how can I do this grouping...