>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.