1 Reply Latest reply on Sep 1, 2009 2:02 PM by comment_1

    Balances in accounting database

    laneystewart

      Title

      Balances in accounting database

      Post

      I have a database that has financial data, (deposits, items paid and encumbered) for 6 seperate types of accounts.  I have set up a tables to give me the correct account information according to that type code (2,4,6 or7).  Now I need to develop a layout that I can get balances to calculate when a user chooses an account to view the detailed account actions on.  

       

      The data entry all goes into one table right now, so I can not use the index number tied to the record that has been suggested here in the past.  I have tried to get a found set(by account number) and If the record number is not 1 then use the GetNthRecord(this record number -1) to get the previous balance from the record above it.  This is not working.  Does anyone have a database like this and how have you created a running balance in this type of environment?  Any help would be great!