You are aware that access web apps will cease to work next year? It is still available only to give developers time to move their applications to another platform.
See the start of this link
However with regards your question, you would need to do a running sum in the underlying query. Use a subquery in your main query something like
SELECT *, (SELECT SUM(Amount) FROM myTable T WHERE TranDate<=myTable.TranDate) AS RunningSum
ORDER BY TranDate