Friday, December 23, 2011

How do you write a query in MSAccess to update all "Nulls" to "0"?

I have a table in MSAccess which has 10 columns of different types of revenue. Some of the cells are not populated. I want to write 1 query to update all 10 columns so the Nulls are changed to 0. I know how to do this using 10 individual queries, but I would like to do it in 1 step.

0 comments:

Post a Comment