How can I get Access to get an average of the next 10 days orders. See example picture.
So todays date is the 20-Mar as highlighted in orange. I need to get the average of the next 10 days orders (21st to 30th March), the ones highlighted in Green. To give me the figure in Blue.
But I also need to carry this down so 21st March will get an average of 22nd to 31st March, etc, etc.
Anyone know some coding to get this?
So todays date is the 20-Mar as highlighted in orange. I need to get the average of the next 10 days orders (21st to 30th March), the ones highlighted in Green. To give me the figure in Blue.
But I also need to carry this down so 21st March will get an average of 22nd to 31st March, etc, etc.
Anyone know some coding to get this?