Historic Value acumulate


I need to build a table as described below:
- the table has a field with text, date, and values (incoming and outcoming )
- I need to calculate in another field: Incoming - outcoming + balance
- the balance is a historic value calculated based in the first entire.

How can I built this calculate?


Have you ever solve this? I need type of this also to create my FIFO stock costing

Please kindly advise, thanks


Did you ever solve this? It looks like this is some sort of transaction based system? If so, I would use two tables.. One that holds the balance, which is a sum of the second table which is the transactions.. If you have a child table you can create an SUM Number field that will sum the transactions and give you a running balance.