If Blank or Null Grab Previous Value

[Kaloyanides]

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!

[Kaloyanides]

Trying this.... But not working......
iif([itemcost]<>0,[itemcost],IIf(IsNull([itemcost]) and DLookUp("[itemcost]","TBLTEMPCOSTINGTABLE2","[ID]=[ID]-1")>0,DLookUp("[itemcost]","TBLTEMPCOSTINGTABLE2","[ID]=[ID]-1"),0))

[Gina Maylone]

Try this: DLookup("yourfield","yourtable","RecordID = " & Me.RecordID -1)

[Gicu]

You would need to use a cartesian join (product) to get all the dates from a Dates table -download the sample from this forum and adapt it to your need:https://www.accessforums.net/showthread.php?t=74995.

Cheers,
Vlad