SQL query in Access update multiple fields

Question

Using MS Access, can I run multiple UPDATE statements in one SQL query?

Say I have a table with columns A-F. What I want to do is this:

UPDATE table SET C = NULL WHERE C = 0
UPDATE table SET D = NULL WHERE D = 0
UPDATE table SET E = NULL WHERE E = 0

I understand that with SQL Server I could use a 'GO' after each line but that doesn't seem to work with Access. Is there an alternative, or do I just have to run a load of separate queries?

Eugen Rieck · Accepted Answer · 2012-12-09 22:48:19Z

9

UPDATE table SET 
  C=IIF(C=0,NULL,C),
  D=IIF(D=0,NULL,D),
  E=IIF(E=0,NULL,E)
WHERE
  C=0 OR D=0 OR E=0

answered Dec 9, 2012 at 22:48

Eugen Rieck

65.6k10 gold badges75 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tom Collins Over a year ago

This is a correct answer to your question. But an added note just case you or someone else reading this sees it, you can only update one table at a time.

Collectives™ on Stack Overflow

SQL query in Access update multiple fields

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related