Dear All,
I want to maintain a simple table with fields such as Transaction Date, Particulars, Debit, Credit, Balance. Following is an example of the table. I want the Balance field to be auto-calculated. I would want to input the initial balance from previous month (example 1000) and continue adding the expenses or new income under Debit and Credit fields respectively. If Credit is null, I want new Balance value to be old Balance value-Debit. If Credit is not null, then new Balance should be old Balance+Credit.
Transaction Date Topic Debit Credit Balance 1000.00 1-Nov-18 Dinner 100.00 900.00 2-Nov-18 Salary 5000.00 5900.00 3-Nov-18 Shopping 250.00 5650.00
Please let me know how this can be achieved in a Query or Form. Thanks very much in advance.
Regards.