Benades
-
Posts
38 -
Joined
-
Last visited
Community Answers
-
Benades's post in Running Balance per Transaction was marked as the answer
I have found my solution below and just tweaked it to my application
(SELECT SUM(IsNull([@field:Debit],0) - IsNull([@field:Credit],0)) FROM tbl_user_trans_hist WHERE user_ID= target.[@field:user_ID] AND Date <= target.[@field:Date])