Solved: Show Numbering on a Report

[Joe Heym]

Hi
I have a report with a group header and detail coming below each group. What I am trying to do is and numbering to the report I want the groups to be numbered 1,2,3.... and the detail to be numbered 1.1,1.2,1.3... 2.1,2.1,2.2 and so on. Something like this:

1. Group Header1
1.1 Group one Detail One
1.2 Group one Detail Two
1.3 Group one Detail Three
2. Group Header2
2.1 Group Two Detail One
2.2 Group Two Detail Two
2.3 Group Two Detail Three

Any ideas would be much appreciated. Thanks


Joe

[matthewspatrick]

By far, the easiest way to accomplish this would be to have the outline numbering show up in your query; to make that happen, you might want to stash the numbering scheme in a table(s). Alternately, there may be a "running sum" way to make it happen.

For starters, please post the SQL for the query underlying your report.

Patrick

[XLGibbs]

Hi Joe,

This method from your continuous form question might be applied in the report design view using labels...

http://vbaexpress.com/forum/showthread.php?t=7040

[Joe Heym]

Many thanks. I've used a combination of running sums, it isn't particularly neat but it works.

Regards

Joe

[matthewspatrick]

Glad to help, Joe.