How to Update a Null Access Query

The "Is Null" function is used for Null values in Access and represents any empty fields in your database. Access queries help you to find Null values and replace them with the values you want to include. For example, you can instruct the query to find Null values in your Products table, where the Cost column is empty for green beans sold in your company. The Null values for the cost of green beans are then updated with the cost you want to include.

• 1

  Open the Access database you want to update.

• 2

  Click "Queries" in the navigation pane and right-click on the query you want to update. Select "Design View" from the pop-up list.

• 3

  Go to the table in the top pane. Double-click the field containing the NULL values you want to update. The field is added to the bottom pane.

• 4

  Go to "Criteria" text field in the bottom pane for the field you added. Type in "Is Null" without the quotes.

• 5

  Click the "Design" tab and select "Update" from the "Query Type" group. An "Update To" text field is added to the bottom pane.

• 6

  Type your update into the "Update To" text field. Add quotes to text values, but not numeric values.

• 7

  Click the "Design" tab and select "Run" from the "Results" group to run the query." Click "Yes" at the prompt to accept the update.