If anyone is looking for SQL DBA training, I would like to recommend SQL School (www.sqldbatraining.com) where I am a current student. The instructor is highly skilled in SQL and...

Thank you very much. I just posted a reply on the other form for errors I got when I parsed.

Thanks for your replies. I will try them out during the weekend and get back if I am not able to do it. Once again thanks.

Vladan,

Your code worked perfectly.

Thanks

I will try to implement your code and see what happens.

I was playing around with my code and I was able to calculate Amount2 for previous year but I am...