Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2009
    Posts
    2

    Unanswered: Retrieve Multiple Records

    I have a table which has the following fields
    Serial No----- Installed Date
    x 01/01/09
    y 01/03/09
    z 01/05/09

    I would like to write a query that would be able to retrieve as below

    Serial No--- Installed Date--- remove Date
    x 01/01/09 01/03/09
    y 01/03/09 01/05/09
    z 01/05/09

    Can this be done?
    Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so how or where is the remove date stored
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Oct 2009
    Posts
    2
    The next record in the table is installed on the date the previous one is removed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •