Can't get report to group by specific numbers

T

trav

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
 
D

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

trav

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

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

Marshall Barton

trav said:
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
Click to expand...


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