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][PrevEndNum]
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
[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][PrevEndNum]
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