Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007
    Location
    Columbia SC
    Posts
    81

    Unanswered: DLookUp("sDate","stepauto"," [Auto] =" & [Auto]+1)

    SELECT stepauto.name, stepauto.fname, stepauto.sDate, stepauto.[auto], DLookUp("sDate","stepauto"," [Auto] =" & [Auto]+1)

    how could i acheive the same result from sql server. I tried select but confused with [Auto] Stuff. I need to compare and get the diefference between two sDate and wanna show there difference .


    Thanks

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Try:

    SELECT stepauto.name, stepauto.fname, stepauto.sDate, stepauto.[auto], (SELECT sDate FROM stepauto AS Alias WHERE Alias.Auto = stepauto.Auto + 1) AS Whatever
    Paul

Posting Permissions

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