Hello experts.
Because my english is poor, I help my self with the picture.

Name:  pp2.png
Views: 224
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