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

 

[Uncle Gizmo]

Are you able to write a query (for one column only) which will return a list of all the empty rows for that individual column?

 

[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

 

[Uncle Gizmo]

I understand.

 

[Uncle Gizmo]

You will need to write 20 separate queries. Alternatively you could modify your table so that it takes advantage of Microsoft Access properly and do it with one query.

 

[Uncle Gizmo]

It looks very likely that your table could do with some modification. Have a look at the thread linked to below and this will explain the problem I see, and also a simple solution. There are also video instructions if your are allowed to watch YouTube videos.

http://www.access-programmers.co.uk/forums/showthread.php?p=671226

 

[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 :/

 

[Uncle Gizmo]

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 :/

I think you should be able to see my previous post which answers this question.