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

    Red face Unanswered: Acumulated in the last 12 months

    Hi,

    Could you help me, please??!!

    I created one query with the year-month and the total product by year-month.

    I would like to know, how I can accumulate in the last 12 months the products by year-month.

    Today I have this: I need this:

    1 2008 01 200801

    1 2008 02 200802

    7 2008 03 200803

    3 2008 04 200804

    4 2008 05 200805

    3 2008 06 200806

    9 2008 07 200807

    2 2008 08 200808

    4 200809 200809

    5 200810 200810

    0 200811 200811

    3 200812 200812

    1 200901 200901

    2 200902 45 200902 sum between 200801/200902

    2 200903 46 200903 sum between 200802/200903

    3 200904 48 200904 sum between 200803/200904

    2 200905 43 200905 ...

    2 200906 42 200906 ...

    4 200907 42 200907 ...

    4 200908 43 200908 ...

    2 200909 36 200909 ...


    Thank you!

    Regards,

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    what have you tried already? got code?
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

Posting Permissions

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