I apologize for not getting back very quickly, I had to stop working on this project and start something else. :w00t: The giftid column is not nullable, it's...

Thanks for code. It ran quickly, but did not return the correct data. Since I did find the coding to get the correct data, I can live with...

I'm sorry, but that didn't limit the data - it returned the same data as before. The section of code I changed to this:

(SELECT giftid, SUM(giftdeduct) AS cumGift

FROM dbo.gifts...