[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 330
  • Last Modified:

How to change these Null values?

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...
0
alesha711
Asked:
alesha711
1 Solution
 
BembiCEOCommented:
As it is Access you can just use an update query to construct the sql statement.
Update tableName
Set column = 302
where Worksheet = "B000001"

or something into this direction-.
As I said you can use the access assinstant to create it, just slecte "Update" as the wuery type
0
 
alesha711Author Commented:
Ok thank you I was doing it wrong...
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now