Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2005
    Location
    Delaware
    Posts
    139

    Unanswered: Query/Report question

    Hello;

    Is it possible, on a query level, to make a calculation based on the previous row’s data? I have a query where columns are Date, NewIn, Balance, OpenCount and Worked. Balance equals OpenCount + NewIn. I want to calculate the Worked field. Worked equals the previous days Balance – today’s OpenCount.

    Example:
    Monday, OpenCount = 300 pieces
    Monday, NewIn = 100 pieces
    Monday’s Balance = 400
    Tuesdays OpenCount = 250 pieces
    Monday’s Worked = 150 pieces

    If not on a query level, would it be possible on a Report level? I’m stuck and do not have a clue how to proceed. Could someone point me in the right direction?

    Thanks…
    Larry

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    see if Rudy's efforts to get me through the fabulous theta join will do what you need.

    izy
    currently using SS 2008R2

Posting Permissions

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