S
Steve_A
I have a table and these are the columns I need to work with.
All fields except id are text from a mainframe.
I have added the nextassy column so it is blank
What I am trying to do if possible is to have a query look at the pn, read
its Ind value then look up to the first lower Ind number (ind -1) and take
that pn and populate it in the nextassy field.
Current
id Ind pn nextassy
01 00 122 ______
02 00 123 ______
03 01 2124 ______
04 01 2125 ______
05 02 2166 ______
What is needed
id Ind pn nextassy
01 00 122 ______
02 00 123 ______
03 01 2124 123
04 01 2125 123
05 02 2166 2125
id line 03 has a 01 ind so it looks at the first 00 above it and take that
pn and copys it to the nextassy field of id line 03.
I hope this makes some sense, if not let me know
TYI
All fields except id are text from a mainframe.
I have added the nextassy column so it is blank
What I am trying to do if possible is to have a query look at the pn, read
its Ind value then look up to the first lower Ind number (ind -1) and take
that pn and populate it in the nextassy field.
Current
id Ind pn nextassy
01 00 122 ______
02 00 123 ______
03 01 2124 ______
04 01 2125 ______
05 02 2166 ______
What is needed
id Ind pn nextassy
01 00 122 ______
02 00 123 ______
03 01 2124 123
04 01 2125 123
05 02 2166 2125
id line 03 has a 01 ind so it looks at the first 00 above it and take that
pn and copys it to the nextassy field of id line 03.
I hope this makes some sense, if not let me know
TYI