replace null value with text from another column (1 Viewer)

[Dave_epic]

Hi

I have 3 columns . Column A and Column B and column C.
Column A is my unique identifier.
Column B is fully populated ie no null values.
Column C has some null values.

Where column C has null values I would like to add the corresponding value from column B.

Thanks

 

[Brianwarnock]

To update the table use a update query for colC update to [ColB] crtiteria Is Null

Brian

 

[Dave_epic]

Yes, thanks. That worked. Thought it might be something as simple as an update query.

 

[Darth Vodka]

or define C as nz(tbl_Whatever.C,tbl_Whatever.B)