<div>
Ok thank you I was doing it wrong...
</div>


<div>
<div class="content wysiwyg-content">
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.<br />
Here is what my table looks like:<br />
<br />
Nursing Home.....Worksheet....Line<wbr /> Number.....Column.....Numb<wbr />er<br />
1012587 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B000002 &nbsp; &nbsp; &nbsp; 400 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3159<br />
1012587 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B000001 &nbsp; &nbsp; &nbsp; &nbsp;3000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7989<br />
1012587 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A000001 &nbsp; &nbsp; &nbsp; &nbsp;500 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 299<br />
<br />
For the B000002 work sheet the column should be 302 and for the B000001 worksheet the column should be 301.<br />
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...
</div>
</div>


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...

How to change these Null values?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.