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 comment
Share on other sites

4 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...