Update Table Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is probably easier than I'm making it, but I can't seem to figure it out.
I have a table that was imported from a report text file. In the first
column is a control number that I need to use. The problem is that the
control number only appears on the the first record of the detail for that
control number.
What I'd like to do is check the control field for null and replace the null
value on that record with the control number from the first time I see a
control number. There are multiple, dirfferent, control records within the
table, with varying amounts of detail records after each. So the control
number that I will be using to repalce the null should change whenever I see
a new one.
Thank you for your help.
 
I would export to Excel and insert a new column. Column B is now the control
number column. Fill new column starting with second row --
=If(B2="",A1,B2)
Copy column A. Paste Special - Values.
 
That would work if the control number never changes. But it does, so this
doesn't work. Thank you anyway.
 
You should try it.

If column B has the control number it is listed in column A. If column B is
blank then this row uses the control number from the row above.
 
Back
Top