S
snake
Hi,
I have a report of a query that uses the running sum option and that works
fine when I show on the report all the days needed to be sum, but if I get
only one record the running sum doesnt work, I have something like this
day in out inven running sum result
1 10 10 =10-10=0 0
2 5 15 =15-5=5+0=5 5
3 8 23 =23-8=15+5=20 20
I want only to show the last record (3) and it cummulative sum
(20)...instead as the running sum doesnt work I get this
day in out inven running sum result
1 10 10 =10-10=0 0
2 5 15 =15-5=5 5
3 8 23 =23-8=15 15
On record (3) I want to get (20) instead (15) but only showing on the report
the last record
Report
day in out inven running sum result
3 8 23 =23-8=15+5=20 20
any help is welcome! thanks
I have a report of a query that uses the running sum option and that works
fine when I show on the report all the days needed to be sum, but if I get
only one record the running sum doesnt work, I have something like this
day in out inven running sum result
1 10 10 =10-10=0 0
2 5 15 =15-5=5+0=5 5
3 8 23 =23-8=15+5=20 20
I want only to show the last record (3) and it cummulative sum
(20)...instead as the running sum doesnt work I get this
day in out inven running sum result
1 10 10 =10-10=0 0
2 5 15 =15-5=5 5
3 8 23 =23-8=15 15
On record (3) I want to get (20) instead (15) but only showing on the report
the last record
Report
day in out inven running sum result
3 8 23 =23-8=15+5=20 20
any help is welcome! thanks