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