>How can I do that using Report Designer ? I have tried using variables but still can't get the correct TOTAL (700).
>
>>> Use Title/Summary option at Report pad menu. Check Summary band option on Report Summary box. Place field to be summed up and the Summary portion of the Report form. Click calculation button and set option to Sum and Reset: should be End of Report.
>>> I presume you already know the group option for group sub-totals, if you don't, please reply...

I do use Summary band and put the field LIMIT on it and set Calculation option to SUM and reset at end of report but I get the total 1200 while actually it should be 700.

Here is my sample data: John is one customer, Marry is also one customer and so is Tony.

Name Limit Payment
John 100 5
John 100 10
John 100 30
Marry 300 20
Mary 300 50
Tony 300 80