Results 1 to 4 of 4
  1. #1
    gar is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Nov 2011
    Posts
    39

    Time interval calculation

    I have a table containing a date field and I want to formulate a query with a calculated field which contains the number of days between the date in the present record and the date in the immediately preceding record. This is meat and drink to Excel but I can't see a way of doing it in Access; can anybody else?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,365

  3. #3
    gar is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Nov 2011
    Posts
    39
    Thanks very much for your remarkably prompt, very comprehensive and very helpful response. The example you cited was almost exactly what I wanted. I was aware of the existence of sub-queries but had never used one and the idea of doing so would probably not have occurred. - Problem solved!

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,365
    Good stuff, and thanks for posting back. I'll mark this solved.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 03-30-2013, 05:42 AM
  2. MS Access Response Time Calculation Help
    By qcjustin in forum Programming
    Replies: 9
    Last Post: 12-13-2012, 10:58 AM
  3. Replies: 11
    Last Post: 05-11-2012, 05:36 AM
  4. Calculation for time x hours in table
    By hellojosie in forum Access
    Replies: 6
    Last Post: 11-20-2011, 01:54 AM
  5. Replies: 7
    Last Post: 12-14-2009, 04:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums