filling in gaps

access United States
  • 16 years ago

    I have a table with the following fields

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

    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

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Never trust a programmer in a suit.” - Anonymous