how to calculate total

[rafiq]

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

 

[chiyyoor]

i hav same problem
would like to create a query like table"1","2","3" from(based on) 'master' table
sample db attached herewith
regds
mahmood

 

[khawar]

Use running sum in report it is the place where you can handle this type of things better

 

[chiyyoor]

Use running sum in report it is the place where you can handle this type of things better

i m using this as back-end of vb program
if it possible, i can find op balance n closing balance of particular dates and there are other advantages.