How to reset running total after group change?
Posted: Fri Jun 28, 2013 11:25 am
Hello to you,
group_code item_code amount running amount
A 3 30 30
A 2 20 50
A 1 10 60
Sub total 60
B 2 200 260 ---> should be 200
B 1 100 360 ---> should be 300
Sub total 300
I included above case in attachment, data (in ms-access), report (in mrt) and report output (in pdf)
Please help and thanks in advance.
Regards,
Steven
group_code item_code amount running amount
A 3 30 30
A 2 20 50
A 1 10 60
Sub total 60
B 2 200 260 ---> should be 200
B 1 100 360 ---> should be 300
Sub total 300
I included above case in attachment, data (in ms-access), report (in mrt) and report output (in pdf)
Please help and thanks in advance.
Regards,
Steven