Query criteria using an "Or" operation

[gaker10]

Refers to thread: https://www.accessforums.net/databas...nly-47170.html


I have the query which updates four fields based on a key column. I accidently ran it without putting in values for one of my fields to be updated (the date). Now it won't update anything because all fields must be null for it to do anything. The criteria is that the field is empty or null (Zero String not allowed). Basically, I want my criteria to perform an or operation in that it will update field1 if its null or field2 if its null or field3 if its null etc. Right now it only updates if ALL the fields are null. I'd like to avoid code for this. Query:

[ranman256]

The OR is represented by moving an IS NULL to a different line. You have them all on 1 line.
You will need 1 IS NULL on 4 different lines. (like a stair step)

[gaker10]

Excellent! Thank you.