Results 1 to 4 of 4
  1. #1
    HS_1 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2016
    Posts
    107

    find out overlapping dates

    I don’t know how to approach this one. I have table with start, finish dates and activity type. Ideally when one activity is complete then the other should start but I found out they overlap.
    In the example below activity A&B overlap by 10 days


    Start Finish Actv
    7/1/18 7/31/18 A
    7/21/18 8/10/18 B
    8/12/18 8/25/18 C
    Is there a way to find out which dates overlay, by how many days and generate a some type of report listing those?

    Thanks

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  3. #3
    HS_1 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2016
    Posts
    107

    looping code doesn't loop

    orange;thanks for the quick replay, it is exactly what I was looking for.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Happy to help and glad that Paul has the website!

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

Similar Threads

  1. Find 2 most recent dates
    By cmiley in forum Queries
    Replies: 17
    Last Post: 01-19-2017, 04:57 PM
  2. Overlapping Dates causing duplicates in query
    By AishlinnAnne in forum Database Design
    Replies: 3
    Last Post: 08-31-2016, 06:09 PM
  3. Find gaps in Dates
    By soldat452002 in forum Queries
    Replies: 5
    Last Post: 07-31-2016, 03:57 PM
  4. Overlapping Dates in Totals?
    By aellistechsupport in forum Queries
    Replies: 3
    Last Post: 02-01-2016, 08:03 PM
  5. How to query for overlapping dates
    By DavidZ in forum Queries
    Replies: 7
    Last Post: 03-10-2015, 01:54 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