Hi All
I have the following dataset:
Itemnumber
Start date
End date
Pricelist name
Price
My challenge is to write a Query, that will give me the Price on any given date.
I would like the Query to ask me what date the returned Price should be based upon. For example i'll punch in 20170215 and the Query will automatically return the Price(s) where this date falls within the date interval.
I have attached a data example to illustrate my point...
Hope to hear and lean from the wiser...
Jesper
Bookmarks