Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    3

    Unanswered: DSUM on multiple criteria!!

    I need help....!

    I have a query that contains many fields but the three relevant to this case are:

    As of
    Ctr #
    Net Revenue

    I need to create a field to the right of Net Revenue that keeps a 3 - month rolling revenue total by Ctr #. So, for example,

    As of Ctr # Net Revenue
    1/31/2004 2 $100.00
    2/29/2004 2 $100.00
    3/31/2004 2 $100.00
    4/30/2004 2 $100.00
    1/31/2004 4 $100.00
    2/29.2004 4 $100.00
    3/31/2004 4 $100.00
    4/30/2004 4 $100.00
    etc...

    would become
    As of Ctr # Net Revenue Rolling 3 Month
    1/31/2004 2 $100.00 $300.00
    2/29/2004 2 $100.00 $300.00
    3/31/2004 2 $100.00 $300.00
    4/30/2004 2 $100.00 $300.00
    1/31/2004 4 $100.00 $300.00
    2/29.2004 4 $100.00 $300.00
    3/31/2004 4 $100.00 $300.00
    4/30/2004 4 $100.00 $300.00

    any help would be greatly appreciated!

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    And your table structure is... ?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    May 2004
    Posts
    3
    Teddy, I'm sorry, I'm somewhat new to Access. What do you mean by table structure? All the info in the query comes from the table Center Aging Totals.

Posting Permissions

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