Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    12

    Unanswered: Summing Last 4 Weeks Data every week

    It sound simple enough but I couldn't figure it out. How do you sum numbers for a 4 week period every week?

    EX:

    Week Qty
    ----- ----
    1 10
    2 20
    3 30
    4 40
    5 50
    6 60

    Result:

    Week Qty
    ----- ----
    4 100
    5 140
    6 180

    Any help would be appreciated

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    As answered elsewhere, a DSum or subquery. Search for running sum.
    Paul

  3. #3
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    Paul's right.

    But I see something else that's missing, to my mind. If you had a date somewhere in the table, maybe a week-ending date, it might make matters easier for you...

    Sam

Posting Permissions

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