Update table where column cell is empty

[Heidestrand]

Hello,

I have a small problem: I have a table with over 20 columns. In every column there are some 1's, but the other cells or tuples are empty. In these empty cells I want to write a 0. So I need an UPDATE query.
But what should I write for the WHERE condition? So he should check every cell and if there's no 1, write a 0.

Can you please help me very quick? Thanks in advance =)


Best regards,

Heide

 

[Heidestrand]

Actually I wanted to update all columns at once.
I could write one for one column, saying like:

UPDATE tbl1
SET c1 = 0
WHERE c1 ISNULL;

But I have like 20 columns in my table

 

[Heidestrand]

Thank you for your answer, Uncle Gizmo.

I'm curious, how would I modify my table to take advantage of Microsoft Access?
I'm still new to Access :/