How to make Ledger Balance ( AR, AP ) in Access Query ( DO LOOp WHile LOOP)
I want some body to please make this balance column in QUERY.
I also attache simple accdb file please consider it to work for this thread.
TransactionID TransactionDate SupplierName Description Debit Credit Balance Opening Balance 5000 1 11-03-2015 ABC Receive material 10000 0 15000 2 11-03-2015 ABC Paid Cash 0 8000 7000 3 12-03-2015 ABC Receive Material 4000 0 11000