personalized grouping intervals

C

cjman

I would like to see personalized grouping options in reports. The grouping
options they have are great but it would be nice to personalize the
selections, especially with numbers. For example, I need to group by
hundreds then thousands then eventually by all greater than 10,000. It would
be nice addition to the program to create these intervals in the grouping
intervals than in VBA or queries.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...2d22cbade3&dg=microsoft.public.access.reports
 
R

Rick B

You can already do that. Either group by the number divided by 1000 as your
first option. Or pull out the nth character of the string value.


Grouping option...

=[SomeField]/1000
=[SomeFild]/100
etc.


--
Rick B



cjman said:
I would like to see personalized grouping options in reports. The grouping
options they have are great but it would be nice to personalize the
selections, especially with numbers. For example, I need to group by
hundreds then thousands then eventually by all greater than 10,000. It would
be nice addition to the program to create these intervals in the grouping
intervals than in VBA or queries.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
Click to expand...
http://www.microsoft.com/office/com...2d22cbade3&dg=microsoft.public.access.reports
 
M

Marshall Barton

There's no need for such a specialized capability, I would
prefer a more generalized Partition function if anyone were
going to spend any developement/test time on this kind of
feature.

The Switch function can be used to do what you want by
setting the grouping expression to:
=Switch([field]<100,1, [field]<1000,2, [field]<10000,3,
True,4)
 
C

cjman

Thank You. The switch function will work.

Marshall Barton said:
There's no need for such a specialized capability, I would
prefer a more generalized Partition function if anyone were
going to spend any developement/test time on this kind of
feature.

The Switch function can be used to do what you want by
setting the grouping expression to:
=Switch([field]<100,1, [field]<1000,2, [field]<10000,3,
True,4)
--
Marsh
MVP [MS Access]



I would like to see personalized grouping options in reports. The grouping
options they have are great but it would be nice to personalize the
selections, especially with numbers. For example, I need to group by
hundreds then thousands then eventually by all greater than 10,000. It would
be nice addition to the program to create these intervals in the grouping
intervals than in VBA or queries.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...2d22cbade3&dg=microsoft.public.access.reports
Click to expand...
Click to expand...
 
Top