Hi, i am trying to calculate total in feild but it doesnt work. I have to calculate credit and debit but when i am trying credit - debit it is showing result of particular row but i have 2 put last total to show actual result.
example
Count desc cr dr total
1 a 1 0 1
2 b 0 1 -1 ( here i have to declare 0 for orignal result)
i am trying update querry which is as follows:
UPDATE Customer INNER JOIN Memo ON Customer.Count = Memo.Count SET Memo.Total = Memo.Credit - Memo.Debit;
plz let me know what i have to do for actual result.
Regards
Rafiq
example
Count desc cr dr total
1 a 1 0 1
2 b 0 1 -1 ( here i have to declare 0 for orignal result)
i am trying update querry which is as follows:
UPDATE Customer INNER JOIN Memo ON Customer.Count = Memo.Count SET Memo.Total = Memo.Credit - Memo.Debit;
plz let me know what i have to do for actual result.
Regards
Rafiq