Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Value of Previous Record (Access 2000)

    I have a table using the fields:

    Month (text)
    Received (number)
    Assigned (number)
    Outstanding (number)

    Results:

    Jan 10 3 7
    Feb 14 7 7
    Mar 10 5 5

    I need to produce a query with an expression to calculate the sum for the Outstanding value of both the current and previous records. Results of query would be:

    Jan 10 3 7
    Feb 11 4 7 14
    Mar 10 5 5 19

    I've searched the MS Knowledge base and found an article which only allowed retrival of a previous record using the MAX function .... which will not work for what I am trying to accomplish.

    Any assistance in solving this would be greatly appreciated.

  2. #2
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Value of Previous Record (Access 2000)

    If what you want is a running sum total in the query, some examples (that use the DSum function) are provided in MSKB 208714:

    ACC2000: How to Create Running Totals in a Query

    HTH

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Value of Previous Record (Access 2000)

    PERFECT ... it is exactly what I have been searching days for .... THANK YOU!!

Posting Permissions

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