Running Sum Troubles

[royalrochelle]

I am stuck and I know this board can help me. I have created a survey database and I created a report that shows all surveys for all scholars. Each survey has two different sections (section A and Section B). So let’s say survey one has a total of 14 questions. Section A has 6 questions and sections B has 8 questions. I want to number each record per survey and then the numbering starts all over again when there is a new student or a new survey. Example below:

Survey 1
Student: Mary Smith
Section A
1. Question
2. Question
3. Question
4. Question
5. Question
6. Question


Section B
7. Question
8. Question
9. Question
10. Question
11. Question
12. Question
13. Question
14. Question
So I made a text box in the detail section and called it txtRunningSum. The control source =1 and the running sum is over group. What I get is the following:
Survey 1
Student: Mary Smith
Section A
1. Question
2. Question
3. Question
4. Question
5. Question
6. Question
Section B
1. Question
2. Question
3. Question
4. Question
5. Question
6. Question
7. Question
8. Question

Can someone please tell me how I combine sections A and B to get what I want? Thank you so much in advance!

[apr pillai]

Create Sorting and Grouping on Student Name, Section & Questions Order on the Report. Create Group Header/Footer on Student Name only, place Section and Questions on the Detail Section. You can set the Hide Duplicate Property value of Section to Yes to suppress displaying Repeating Section values.

[rpeare]

You can also do this using an unbound control

Create a text field in you detail section and make it's control source =1

In the RUNNING SUM property of that text box to OVER GROUP. As long as you have a group header and footer for your different sections (which it appears you do) the line numbering will start at 1 for each new section.