If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
repeat previous record if blank
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 |
Thread Tools | |
Display Modes | |
|
|