Can't get report to group by specific numbers

[Guest]

I have a report that I would like to group a range of percentages together 1%
- 10%, 11 % to 20%, and so. and then sum the total at the end of the group.
The only problem is there are several percentages in one group

Teams Percentages Score
A 40% 75
A 35% 75
TOTAL 35% - 40% 150
A 100% 100
A 90% 100
TOTAL 90% - 100% 200

It this possible?

Thanks,
T

 

[Duane Hookom]

You can group by expressions such as
=Int(YourField * 10)
or something similar.

If this doesn't answer your question, please come back with additional
requirements.

 

[Guest]

Duane,
Thanks,
What happens if I need to change the groupings without intervals of 10?

 

[Duane Hookom]

You create a table of intervals/ranges with min, max, and titles of
intervals. You can then include this table in your report's record source so
you can group by the min or max values.

 

[Marshall Barton]

I have a report that I would like to group a range of percentages together 1%
- 10%, 11 % to 20%, and so. and then sum the total at the end of the group.
The only problem is there are several percentages in one group

Teams Percentages Score
A 40% 75
A 35% 75
TOTAL 35% - 40% 150
A 100% 100
A 90% 100
TOTAL 90% - 100% 200

Can't you just group on the percentage field and set the
Interval to 10 (or is it .1?)