Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2002
    Posts
    108

    Unanswered: Anyone created a bank register

    Has anyone created a bank register ?
    Specifically I am trying to come up with a way of keeping the running total/balance.
    I could keep the balance on each item but wonder how hard it will be to keep that balance up, as in the case where a previous check or deposit has to be changed or voided. This would throw off all calculations after that record.
    Anyone have a better/smarter suggestion ?

    Using ACC2003

    Thanks in Advance !

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Yes; don't try to store the running total. Just calculate it on the fly.
    Paul

  3. #3
    Join Date
    Feb 2002
    Posts
    108
    That brings up another question. Is it possible to show the balance on each line in a list format such as a check book register ?

    It is easy to show the ending balance (just show the diff between the sum of deposits and the sum of the debits), but I cant get my thinking around a way to show balance after each debit and deposit.

    Thanks for the help.

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Sure, as long as there is a field or fields that can be used to order the records appropriately. The balance for any given transaction is the sum of all the transactions which preceded it, including that transaction (or in this case, sum of deposits less sum of debits).
    Paul

  5. #5
    Join Date
    Feb 2002
    Posts
    108
    Thanks, I will give it a try.

  6. #6
    Join Date
    Feb 2002
    Posts
    108
    I am still having a problem,

    To do this, I assume I have to use a running sum. Is that possible on a form ?
    I know how it works in reports, but dont know how in forms.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •