Hi all,
I have a report, grouped by day then by some ID. If I use a textbox with ControlSource=1 and RunningSum OverGroup/OverAll I have the results shown below, different from what I need (restart after each day). Any suggestions ?
ex: .........................................................REPORT
runSum..runSum .....number.................... 01ian2019
overall...overGroup...I need ..................ID.........VALUE
....1........... 1..............1.................... 1000.......300
....2 .......... 2 .............2 ................... 1000.......350
........................................................total for id1000=650
....3............1..............3.....................1001........200
....4............2..............4.....................1001........600
.........................................................total for id1001=800
........................................................TOTAL for 01ian2019=1450
...........................................................02ian2019
....5 ...........1..............1......................1002.......450
....6............2 .............2 .....................1002.......620
......................................................... total.....
I have a report, grouped by day then by some ID. If I use a textbox with ControlSource=1 and RunningSum OverGroup/OverAll I have the results shown below, different from what I need (restart after each day). Any suggestions ?
ex: .........................................................REPORT
runSum..runSum .....number.................... 01ian2019
overall...overGroup...I need ..................ID.........VALUE
....1........... 1..............1.................... 1000.......300
....2 .......... 2 .............2 ................... 1000.......350
........................................................total for id1000=650
....3............1..............3.....................1001........200
....4............2..............4.....................1001........600
.........................................................total for id1001=800
........................................................TOTAL for 01ian2019=1450
...........................................................02ian2019
....5 ...........1..............1......................1002.......450
....6............2 .............2 .....................1002.......620
......................................................... total.....