Query for previous day's ending

hmho

Registered User.
Local time
Today, 11:56
Joined
Apr 7, 2009
Messages
93
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
 

Users who are viewing this thread

Back
Top Bottom