Hi,
I am using below formula for another DB and working fine and showing current balance, now in another DB i have different scenario like
A_Bal: Val(DSum("nz([debit],0)-nz([credit],0)","vdebts","vids =" & [vids]))
Vids is a vendor ID numeric
Tr is transaction ID in same table as numeric...