Report running sum

[jun-ior]

Hi All!
I did a report running sum from my checking account. Works fine on Ascendant, but I want it to work on descendant. The table is date/notes/Amount. On the report I have date/notes/amount/balance. What can I do to reverse it to make the new date to be on top of the page and make the balance as well, if that is possible?
thanks
Jr.

 

[PNGBill]

I don't think it is possible to have Running Sum desc sort.

If this is so, then a solution may be to use a query rather then a table to run your report.

Have the query sort desc.

Add a calculated field to hold the balance.
This is the tricky part.

If the Balance Field could be Daily Balance only then you could use the record source for this to be a function that calculated the balance at the end of each day.

Also, at the top of the Report or Form, you could have a Field that held the Balance. this could be a Calculated Field (sum) or use a function for it's record source.