Running sum in detail records

[bustersports]

Hi,

I have looked at multiple examples of doing a running sum over a list of detail records. None of the examples provides the solution I am looking for.

What I want to have is a report that looks like this.

No. Aisle Bin Box ID Qty
---------------------------------------------
Order Number Header 123456(is hidden)used to group by

Aisle Header AC
1 ABC 123 34
2 DEF 456 156
3 GHI 789 98

Aisle Footer would read 3 boxes for this aisle (displayed)
AE
1 XYZ 123 34
2 JKL 456 156
3 MNO 789 98
4 YYY 123 45

Aisle Footer would read 4 boxes for this aisle(displayed)

Order Footer would read 7 boxes for this order(displayed)

Note that the numbering starts over when the Aisle changes. What is happening is when I use No. box Control Source = 1 and Running Sum = Over Group, the first 2 lines will be 1, then on the third line it will be 2, then 3, etc. It also does not go to 10, but starts over (I verified the text box size will hold 4 digits, I manually entered it to verify). If I make the text box Running Sum = Over All, I get a running sum across all of the detail records, which is what I would expect to see.

I am grouping, in this order - Order Number, Bin, Box ID

In summary, when the Aisle changes, I want the box numbering to start at 1 again. I hope this is enough information to allow someone to see what the problem is.

Thanks in advance for at least looking at it.

 

[dhookom]

If you are

grouping, in this order - Order Number, Bin, Box ID

you won't get numbering based on Aisle. You would need to group by Aisle. How did you get 1 Aisle header and to Aisle footers?


Duane
Hook'D on Access
MS Access MVP

 

[bustersports]

Dhookom,

Thanks for the great catch. That fixed the problem.