Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011
    Posts
    1

    Question Unanswered: Grouping Volume Numbers from Weekends to the Friday Prior

    Hi,
    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.

    Current State:
    Friday 9/30 150 units
    Saturday 10/1 12 units
    Sunday 10/2 5 units

    Desired State
    Friday 9/30 167 Units

    I also want to move the volume and then exclude weekend dates all together if possible.
    Thanks

  2. #2
    Join Date
    Nov 2010
    Posts
    84
    Did you like this?
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •