BHScripter
Technical User
Hi:
I need to list a payment schedule for a quote sheet for a potential lessee. My SQL query returns the lease month term as an integer which could be 6, 12, 4, etc. It also returns the proposed lease start date, lease end date, and the monthly rent being quoted. Within my report, it is easy to get to the payment schedule for the first month and the last month since they are named months within the query. However, I need to somehow list the the months in between in #'s such as month 2, month 3, etc. with the monthly payment (the monthly quoted rate). I want it to work so that only the correct # of months show up based on the quoted lease term. I was thinking some sort of crosstab but not sure how to set up the formula to get the month's in between the start and end month to show up in the crosstab.
Thanks for any help.
I need to list a payment schedule for a quote sheet for a potential lessee. My SQL query returns the lease month term as an integer which could be 6, 12, 4, etc. It also returns the proposed lease start date, lease end date, and the monthly rent being quoted. Within my report, it is easy to get to the payment schedule for the first month and the last month since they are named months within the query. However, I need to somehow list the the months in between in #'s such as month 2, month 3, etc. with the monthly payment (the monthly quoted rate). I want it to work so that only the correct # of months show up based on the quoted lease term. I was thinking some sort of crosstab but not sure how to set up the formula to get the month's in between the start and end month to show up in the crosstab.
Thanks for any help.