A
ave
I have a query for historical inv with fields
Part - Date - Qty
Sample data
x - 1/1/04 - 5
x - 1/2/04 - 5
x - 1/3/04 - 5
x - 1/4/04 - 10
I would like result set to show only the records where the NEXT record has a
different QTY then the prior record
So for the above it should read:
x - 1/1/04 - 5
x - 1/4/04 - 10
Any ideas on how to accomplish this?
thx in advance
Part - Date - Qty
Sample data
x - 1/1/04 - 5
x - 1/2/04 - 5
x - 1/3/04 - 5
x - 1/4/04 - 10
I would like result set to show only the records where the NEXT record has a
different QTY then the prior record
So for the above it should read:
x - 1/1/04 - 5
x - 1/4/04 - 10
Any ideas on how to accomplish this?
thx in advance