How to check next field value

[jozef_klimo]

Hi all,

I have following table..

and I need figure out how to check next value

If value is 150 and next value is 160 then [Result] must be 0

If value is 150 and after is something else value from field [Time] must stay same also in field [Result].

ID	Description	Time	Result
130	SMT	1,14	1,14
110	Prehandling	3,04	3,01
150	Manual assembly	8,44	0
160	Wave soldering	1,4	0
180	Quality Control	1,8	1,8
290	Other testing	1,5	1,5
150	Manual assembly	0,35	0,35
220	ICT	0,7	0,7

[sunny_talwar]

I guess you will need to sort in descending order because you cannot check next value in the script, but you can check the previous value using Peek/Previous but use descending sort order