Running balance using the previous balance date

N

Nadine

Hi,
I am experiencing the some difficulties trying to add a running balance in a
form taking the balance of the previous date where the selected account was
modified enter in consideration.
My question is how to express in Ms Access Current Balance
=Previous balance + Debits -Credit. Where previous balance is the balance of
the latest day the account was modified.
In my table I have the following fields:
Transaction_ID
Account#
Date
Credit
Debit
Balance.
Please I need your help.
Nadine
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top