Update Query Help?

[Jimmy2128]

I have a table that contains Column A and B. I need to update all Null values in Column B with values from Column A.

Thanks

James

 

[M8KWR]

the query would be:

UPDATE Table1 SET Table1.[Column B] = [Table1]![Column A]
WHERE (((Table1.[Column B]) Is Null));

Hope this helps

 

[Jimmy2128]

Excellent! Thanks