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