Hello experts.
Because my english is poor, I help my self with the picture.
Name: pp2.png
Views: 205
Size: 10.4 KB
I need to calculate the unpaid sum.
The unpaid or sum(reste) is 10 + 25.
What I did is:
Code:
Select Sum(Reste) As TotalSum from Rec_tbl group BY Cs_ID
Debug.Print TotalSum
The output is: 70 instead of 35
Thank you