Lynn,

Thanks for your response.

Worked out fine

Lynn,

Sorry, maybe I was a little unclear. I have a TABLE with the data already in it. I am not trying to create the table. I was just wanting to...

Thanks Lowell.

I will give it a try.

Thank you both for the replies.

I have not explained it very well, but I think now I understand what the Case statement is doing. It really is doing what...

I was thinking DTS. Just have never used it. I found some good information in the Articles.

Thanks for the input

Peter,

I have just ran my query. Speed is not an issue.

I am not sure what you are doing with your statement. Ray's was easier for me to understand....

RayM, Thanks for very much this worked fine.

Thanks for the reply, but 2000 was just my example because today's date is 9/18/2007.  I don't want to hard code the years, I just want the statement to calculate...

Thats okay. Don't worry about it. Thanks for the tips again.

Thanks for your assistance, but you don't have to be smart. 

The way you worded it in your breakdown looked to me like you were merging them.  

Sorry if I misunderstood you.

I have tested the statement you suggested. I am getting a syntax error at the line  ) years ).

It looks o.k. to me. Am I missing something?

Thanks

SELECT SUM(CASE WHEN 2006...

Thanks so much! It makes sense now.

O.K. So where he has hardcoded the dates and amounts, I will put the same field name?

It would look like this

CAST(dtFrom AS

Thanks for your suggestions. I understand what you mean about breaking it down, however, I am confused by the following section.

SELECT 1 AS RentID

Thanks for your help. I am pretty sure my problem lies within the fact that the tenant I am looking at has a different rent amount in the 11th month...