Jump to content
  • 0

Return ID depending of variables




I have 2 tables: "Property" and "Lease".

1 property can have N leases.

1 lease have a Start and End dates and also a lease amount.

I woud like to return the current lease (Lease ID and the lease amount)

For example, there are 2 leases:

(1) Jan 1st 2012 to December 31st 2014 for $1000 per month

(2) Jan 1st 2015 to December 31st 2017 for $1100 per month

Today is November 9th 2016. So at the date of today the lease to return is lease #2 and $1100 for the lease amount.

How is it possible to return a row and some data depending of criteria? Datapages? Views? Pivot tables?




Link to post
Share on other sites

4 answers to this question

Recommended Posts


This topic is now archived and is closed to further replies.

  • Create New...