Dear all,
I am unable to calculate running Dsum of opening balance of ledger accounts (above 200 ledgers)
=Nz(DSum("[Debit]-[Credit]","qry_OpeningBalance"),0)
this works very well only for single ledger account, but not working for all ledger accounts in report, for example, i want to see ledgers of 2 accounts i.e Capital and Assets
1-Capital
Opening balance Rs10000
01-01-2021 DR 1000 Rs.11,000
20-01-2021 CR 2000 Rs.9,000
2-Assets
Opening balance Rs-15,000
01-01-2021 CR -1000 Rs.-16,000
20-01-2021 DR 2000 Rs.-14,000
Please resolve my query. Thanks