Can't get report to group by specific numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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.
 
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?)
 
Back
Top