I have a large table for a leasing database, and it includes a column for start dates and end dates of lease terms, and there are up to 11 lease terms. I am trying to write a query that will identify the current lease term, and then another query to identify the current rent rate based on which term is current. I am not having any luck finding references to this type of query. I am thinking I might need to restructure my table, but again, not sure how. Any suggestions?
September 7, 2012 6:33 PM
September 7, 2012 6:55 PM