How to change these Null values?
Posted on 2014-04-14
I have a table with lots of Null values. I have realized why they are Null and I want to change them all to certain values.
Here is what my table looks like:
Nursing Home.....Worksheet....Line Number.....Column.....Number
1012587 B000002 400 3159
1012587 B000001 3000 7989
1012587 A000001 500 200 299
For the B000002 work sheet the column should be 302 and for the B000001 worksheet the column should be 301.
Since the null values are all scattered and I have 11,481 that needs to be changed... is there a query I can run? I tried the update query but it came out blank...