• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Overlapping Dates, Gaps in Dates, Double Counting

    Solved it!! using SQL query in MS Access.
  2. A

    Overlapping Dates, Gaps in Dates, Double Counting

    Hello Narayan, Thanks for re-looking the code. You can ignore the second case where Overlapping dates between IDs is concerned; not required. But the first case is mandatory; i.e. code must take ID into account in deciding the missing dates. To make it simple, Both Overlapping dates and...
  3. A

    Overlapping Dates, Gaps in Dates, Double Counting

    Hi Narayan, Thanks alot for your quick reply. Your help is much appreciated. I'm sure that you will win .. :) -Arun
  4. A

    Overlapping Dates, Gaps in Dates, Double Counting

    Hello Everyone, I'm having the similar case but with around 15000 rows of data. I have say 3 columns, Personal ID, Start date and Stop date. There are several events for a particular Personal ID. Data looks like: id startdate enddate 1 13-Mar-2012 9-Apr-2012 1 12-Apr-2012 7-May-2012 1...
Back
Top