Access 2013 8 week Date gaps in ordering - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit
Expired

Access 2013 8 week Date gaps in ordering

dealondeals Avatar
2y, 5m agoPosted 2 years, 5 months ago
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
dealondeals Avatar
2y, 5m agoPosted 2 years, 5 months ago
Options

All Responses

(3) Jump to unreadPost an answer
Responses/page:
#1
Is the definition of a week a working week or a calendar week?
#2
A calendar week. Thanks
#3
A calendar week. Thanks

Post an Answer

You don't need an account to leave a response. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!