I can't figure out how to update a sales history table based on date.
Item cost.
Let's say, over time, products were sold with an incorrect or $0.00 cost.
Now, I want to run a query to update the sales history table with the item cost most recent to the sell date.
The item may not have been received the same day it was sold, so need to grab the most recent cost from the day it was sold.
Any ideas? Seems complicated... Thx in advance...!