I am trying to develop an accounting application. I have a form for Transaction Entry, which works great except for my Rolling Balance field. I would like the Rolling Balance field to show the balance by account at each record. For example:
Record 1: For Account 123, Transaction Amount equals $100; Rolling Balance equals $100. Record 2: For Account 123, Transaction Amount equals $100; Rolling Balance equals $200. Record 3: For Account 123, Transaction Amount equals $200: Rolling Balance equals $400.