I'm not sure which function is best to use for this...
I have a data table called "tblDelivery" which has delivery date, product name and delivered quantity;
I have another data table called "tblPriceList" which has a list of products and their cost & retail prices, as well as a "Price Date From" and "Price Date To"
When a cost or retail price changes, a new record is added to tblPriceList; "Price Date To" is updated on the old record to show the date as the day before the new price came into effect; the new line is entered with the "Price Date To" column showing the date the new price is effective from, and "Price Date To" is left blank
In tblDelivery I am trying to get the correct cost & retail price of each product as at the date it was delivered. Can anyone help please?
Bookmarks