Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2010
    Posts
    3

    Unanswered: Query - Difference between Dates in a field

    Hi all,

    I am trying to create a query to calculate the longest time between two consecutive dates within set of dates

    eg-

    Dates________Diff

    01/01/2006____0
    04/01/2006____3
    06/01/2006____2
    08/01/2006____2
    16/01/2006____8
    20/01/2006____4
    .
    .
    .

    so I want the overall result to show:

    Dates________Diff
    16/01/2006____8

    Any help would be appreciated. Thanks!

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Look at "DemoDateDiffA2000.mdb" (attachment, zip).
    Look at Query1, (make table query), Query2, SQL, Module1, Form1.
    Open Form1 and click on button.
    Attached Files Attached Files

Posting Permissions

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