Unanswered: Grouping Volume Numbers from Weekends to the Friday Prior
This is probably really simple, but I have looked online and cannot seem to get a good way of doing this particular task. I am collecting monthly volume numbers broken out by date via an Access Query.
Instead of showing weekend volume numbers on a the report, I want to move saturday and sunday volume into the friday prior.
Friday 9/30 150 units
Saturday 10/1 12 units
Sunday 10/2 5 units
Friday 9/30 167 Units
I also want to move the volume and then exclude weekend dates all together if possible.