Report Grouping 1-10, 11-25, 26-50 With SubTotals

[Guest]

User wants a report with customers ordered by total sales descending. They want to see 1-10 then a subtotal, 11-25 then a subtotal of 1-25, 26-50 then a subtotal of 1-50, 51-100 then a subtotal of 1-100, then the remainder (!) of the customers grouped together and a grand total

I have thought about using RunningSum, but my stumbling block is that the groupings are not consistent (10, 15, 25, 50)

Anyone have suggestions as to how to accomplish this

TIA

 

[Terry]

Ellswrth,

Create a new table with two fields (you could probably get
away with one field as an autonumber) populate the first
ten records with 1 in the non autonumber field. This
should result in ten records like:
1 1
1 2
1 3
etc
1 10
then
2 11
2 12
etc
2 25

and so on.

Add this table to your record source and join the
autonumber field to the number you want grouped and group
on the left hand number above.

hth,

Terry

-----Original Message-----
User wants a report with customers ordered by total sales

descending. They want to see 1-10 then a subtotal, 11-25
then a subtotal of 1-25, 26-50 then a subtotal of 1-50, 51-
100 then a subtotal of 1-100, then the remainder (!) of
the customers grouped together and a grand total.

I have thought about using RunningSum, but my stumbling

block is that the groupings are not consistent (10, 15,
25, 50).