# Can't get report to group by specific numbers

=?Utf-8?B?dHJhdg==?=
Guest
Posts: n/a

 29th Mar 2005
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
Guest
Posts: n/a

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

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

=?Utf-8?B?dHJhdg==?=
Guest
Posts: n/a

 29th Mar 2005
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.
>
> 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 Hookom
Guest
Posts: n/a

 29th Mar 2005
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.
>>
>> 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
>> >
>> >

>>
>>
>>

Marshall Barton
Guest
Posts: n/a

 29th Mar 2005
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]

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Rachelle Microsoft Outlook Contacts 1 14th Mar 2008 05:26 PM C-Man23 Microsoft Excel Worksheet Functions 3 19th Jan 2006 10:52 AM C-Man23 Microsoft Excel Worksheet Functions 1 9th Jan 2006 02:23 PM =?Utf-8?B?c2VhMDIyMQ==?= Microsoft Excel Worksheet Functions 2 9th Mar 2005 01:06 AM Carsten Giesen Microsoft Windows 2000 Active Directory 8 8th Oct 2004 02:58 PM

Features