repeat previous record if blank

[Dan]

Good morning,

I am trying to create a query which lists the price per day for a date
range. If there is no price for a particular date however, I wish it to
repeat the price from the previous date. I would prefer to be able to do this
in a query, but if not performing this function in a report would be fine.

For example, in the following I would like the price for the 15/01/2006 to
be entered as 1.05

DATE PRICE
13/01/2006 1.00
14/01/2006 1.05
15/01/2006
16/01/2006 1.01

Thanks very much,

Dan