Debit credit and balance in Query

[SjCc]

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

now i want to dsum the above formula to see balance with respect to the criteria of vendor id and transaction id as well something like

[vids]=[vids]and[tr]=[tr]

All fileds are in same table vdebts

 

[CJ_London]

pretty much how you have written it

A_Bal: Val(DSum("nz([debit],0)-nz([credit],0)","vdebts","vids =" & [vids] & "and [tr]=" & [tr]))

 

[SjCc]

pretty much how you have written it

A_Bal: Val(DSum("nz([debit],0)-nz([credit],0)","vdebts","vids =" & [vids] & "and [tr]=" & [tr]))

Brilliant Thanks a Lot