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.

--
Duane Hookom
MS Access MVP


"trav" <(E-Mail Removed)> wrote in message
news:ED3471E1-BC07-4833-B7F8-(E-Mail Removed)...
>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,
Thanks,
What happens if I need to change the groupings without intervals of 10?



"Duane Hookom" wrote:

> 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.
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "trav" <(E-Mail Removed)> wrote in message
> news:ED3471E1-BC07-4833-B7F8-(E-Mail Removed)...
> >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 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.

--
Duane Hookom
MS Access MVP


"trav" <(E-Mail Removed)> wrote in message
news:E5AB7E19-0417-4019-8E5C-(E-Mail Removed)...
> Duane,
> Thanks,
> What happens if I need to change the groupings without intervals of 10?
>
>
>
> "Duane Hookom" wrote:
>
>> 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.
>>
>> --
>> Duane Hookom
>> MS Access MVP
>>
>>
>> "trav" <(E-Mail Removed)> wrote in message
>> news:ED3471E1-BC07-4833-B7F8-(E-Mail Removed)...
>> >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
>> >
>> >
>>
>>
>>

trav wrote:

>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?)

--
Marsh
MVP [MS Access]