filling in gaps

• • Reply

  16 years ago

  by doddhowell

  doddhowell

  , United States

  Joined 16 years ago

  I have a table with the following fields
  

  
  ShipID = PK
  Sku = Product ID
  Date = Products Trans Date
  ShippedToDate
  

  
  ShipID    Sku    Date    ShippedToDate
  1    AC    10/1/2004       5
  2    AC    10/2/2004    
  3    AC    10/3/2004    
  4    AC    10/4/2004        17
  5    AC    10/5/2004       23
  

  
  in the case of the the empty value what is the best way to have it populate
  from the prior record
  

  Report abuse