Access 2013 8 week Date gaps in ordering

    Hi all
    I have some order data in an access 2013 database in the format of

    orderid,customer_id, orderdate, ordervalue. I have been asked to identify all customers that have 3 weeks or above gaps of not ordering.

    So the output for the 3 week or above not ordering would be customerid gapstartdate, gapenddate.

    Any help would be very much appreciated. Thanks for reading


    Is the definition of a week a working week or a calendar week?

    Original Poster

    A calendar week. Thanks

    Original Poster

    A calendar week. Thanks
    Post a comment
      Top Discussions
      1. Fraudulent site2810
      2. Whoops SNP...Grenfell style cladding all over Glasgow711
      3. Microsoft approve Hyperkin's remake of the OG Xbox controller44
      4. So Brexit isn't going how a lot of Brexiters thought it would2251

      See more discussions