Thanks Kingston,

Its working great! Thanks a million 🙂

Yes, you are right.

sum(weekTarget)from wekk where WKID <= A.WKID is correct.

However what if the user entered a wrong value in the middle of the list? If he makes adjustment/correction...

No error returned, it ran fine, however the value added to the WeekCumulative is incorrect.

To give you a better idea, I'm using an asp.net gridview to update the data....

thanks for your help, however, it doesnt work.

Thanks for your help and advice, Jeff.

thanks Karl.

Thank you all for your help and guidance.

Peter, thank you very much for your help.

What if the date field includes possible future dates?

Thanks again.

Thank you very much for your help, David.

sorry for not being clear, could i get the total for the [Cumulative] column for each week as well? do i need another sproc for that?

Thanks for your help David,

right now i'm cumulative on the percentage of work, how to get the cumulative of the actual work? is it possible?

Thanks again.

thanks, i'll try,

Activities - (Fields - ActID (pk, identity(1,1), ActTitle (varchar50), PercentageofWork(Decimal)

Preparation of Learning Units,25.0

Compilation of Resources, 25.0

Materials Write-up, 20.0

Testing and Certification,30.0

Week - (Fields - WeekID (pk, identity(1,1), WeekNum (int),...

Dear Ryan,

I got it to work. Thank you very,very much for your help.