I have a table full of products we've purchased.
I want to assign a cost or value for each product for each day whether we purchased that day or not.
Example From
Product Purchase Date Cost
ItemA 1/1/2019 $1.00
ItemA 1/3/2019 $2.00
ItemA 1/5/2019 $1.00
Example To
ItemA 1/1/2019 $1.00
ItemA 1/2/2019 $1.00 (carried from prev. record)
ItemA 1/3/2019 $2.00
ItemA 1/4/2019 $2.00 (carried from prev. record)
ItemA 1/5/2019 $1.00
I've tried DLookup but this a bit over my head...
Hopefully someone out there has an easy solution...
Thanks!