>>>Doesnt add,,,it shows the last value using our example is shows 15
>>>is this a good time to mention my table is populated using a cursor?
>>>
>>
>>It doesn't look like you placed the field in the Summary band and check the calculation to SUM.
>>
>>Otherwise it should work and it doesn't matter - was it table or cursor.
>cursor

It was not a question - it was rather a statement :) I needed to add ! at the end.