Simple grouping

[GoodFella]

I have a table that has 10 stores. Each store is grouped by distance (EX: 1 mile, 2 mile, 3 mile... 300 mile). I want to group this further in a report with 5 groupings. EX: 1 - 100 mile, 101 - 200 mile, 201 - 300 mile, etc. Do i have to do this in VBA code? If so how? Is there a way to do this in design mode?

Store 1 | 1-100 | $5,000,000
Store 1 | 101 - 200| $6,000,000
...
..
...
...
Store 2 | 1-100 | $3,000,000
Store 2 | 101 - 200| $5,000,000
...
,,.,
...

Thank You,
Marc

 

[gemma-the-husky]

i think if the bands are fixed widths then access has a ready made function called PARTITION - have a look at that

 

[GoodFella]

i think if the bands are fixed widths then access has a ready made function called PARTITION - have a look at that

ummm yea. Its been a while since ive used access as a reporting tool. Any help in the right direction is much appreciated.

 

[gemma-the-husky]

i've never used it, i just have seen examples of it, and it does exactly what you want.

you need to use it in the query driving your report - look in access help