I am woring on an application that is an accounting ledger for a bank account.  I would like to calculate a running balance based on the date of the transaction for the individual.  Does anyone have any thoughts on how I can accomplish this?  Here are some details:

I am uploading the following data:

- Account Number

- Posting Date

- Transaction Amount

I will also put in a beginning balance for each individual as a starting point called:

- Beginning Balance

Any help would be greatly appreciated..

Thank You

Nick