replacing null values with a number using query in desing view

[damcloodt]

Hello,

I have a column in my database that contains years. Some cells are empty (a Null value). I want to replace these empty cells by a number (i.e. the year 2006), how can I do this using a query in design view? Thanks a lot for your help!

 

[wazz]

off the top of my head:

- put the field in the grid
- put Is Null as the criteria
- check the result and count the rows to see if it looks right
- change the query type to Update
- enter your new value in the grid
- check the results (i think you can do this before actually updating; check the row count)
- run the query to update the values.

try it with a copy of your table.

 

[damcloodt]

yes, it worked!! Thanks a lot!