Hi, everyone,
I have a table like this, I need to fill the field [Location].
Like in the first record, [Scan_Type_ID]='LO' , [Location]=167
I need to fill out rest of [Location] field with the value 167 until I
find another [Scan_Type_ID]='LO' then do the same thing for rest of
table.
Scan_Type_ID Location Cage_ID
LO 167
CC 26678
CC 3669
CC 235689
LO 770
CC 77788
CC 23
LO 17
CC 23123
CC 256
CC 14
CC 56
How can I do this automaticlly, because I have a huge table to update.
Thanks,
Steph