Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009
    Posts
    67

    Unanswered: Query for previous day's ending

    I have Table with these fields (ProdNumber, ReportDate, EndingNumber, SerialNumber) ProductNumber is the key. Then I set up query like this

    [ProdNumber] [ReportDate] [EndingNumber] [SerialNumber]
    123 06/01/09 50 999
    123 06/02/09 60 999
    123 06/03/09 70 999
    What I like to see is another query that will give me another filed for previous day's ending for the same serial number like this
    [ProdNumber] [ReportDate] [EndingNumber] [SerialNumber] [PreviousEndingNumber]
    123 06/01/09 50 999 Blank
    123 06/02/09 60 999 50
    123 06/03/09 70 999 60

    How do write this code in query.

    Thanks

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    One method, again:

    Previous values
    Paul

Posting Permissions

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