Multiple conditional null query

[JMichaelM]

I forget how to do this query. If i have multiple fields which are not null then i want to result in specific text.

Field 2 null
Field 3 null
Field 4 null
Result A

Field 2 null
Field 3 null
Field 4 not null
""

 

[isladogs]

I'm sure your field names aren't as listed. What are they really?

Also what's the name of the table and the field to be updated?

 

[JMichaelM]

Its gonna be something like:

IIF ([Valid] Is Not Null and IIF ([Expired] Is Not Null, "Ok" , ""))

All have to be null for one result.

 

[isladogs]

You ignored my questions.....

 

[JMichaelM]

Figured it out. Thanks.