So, I currently have a query that i export into excel as a weekly report but i need to add some reporting history
So need to show how many times each customer outstanding order has been shown on the reports
So currently have
Customer customer
Order No
OrderDate
Number of days outstanding
need to add and find how to generate the following fields
Date the same customers order appeared on the weekly outstanding reports
1st appeared date
2nd appeared date
3rd appeared date
4th appeared date
not sure best working approach
So need to show how many times each customer outstanding order has been shown on the reports
So currently have
Customer customer
Order No
OrderDate
Number of days outstanding
need to add and find how to generate the following fields
Date the same customers order appeared on the weekly outstanding reports
1st appeared date
2nd appeared date
3rd appeared date
4th appeared date
not sure best working approach