Append query from multiple null fields

[Delta729]

Sorry, title should have said update query... I noticed after the initial post.



I have a database and I'm using an update query to add the word "Exclude" into the Exclude field if the date is missing. This is simple enough for say, if "Submitted Date" is empty, update the word exclude to Exclude field. Right now I'm running four separate a update queries because I've never been able to figure out how to make it work on multiple fields.

I have "Last Date Worked", "Submitted Date", "Validated Date", & "Invoiced Date". If any are empty I need to add the word Exclude to the Exclude field. I'm a novice with Access. I'm learning by doing. I haven't written anything with Sql, I've just created the queries I've used through the query creator.

Any help would be greatly appreciated.

[Delta729]

Disregard... I've figured it out. I've split out the additional date fields onto separate or rows. I always though the first OR row was or for all other columns, but I guess if all on the same row, it would only work if both date fields were empty.