Query iif statement

[MattC66]

Hi All - new here so be kind.
I am trying to set the cell that if it doesn't have an OrderNum then the field is says NO. However when I run it - it shows NO on every line.

Room: IIf(IsNull([OrderNum])=Null,Null,"NO")
Background I have two tables. One with all Orders and one with Orders that contain a product called Rooms. I want a list that shows all the orders and column that has a NO (ideally a check box if it has a room). but I couldn't find a way to do a positive. So I figured I'd just not all orders without a room on the order show "NO".

Thanks in advance.

 

[JonXL]

IIf([OrderNum] IS NULL,NULL,"NO")

IsNull is a VBA function that returns a boolean (true/false) value. To check if a field is null, you just use IS NULL.

 

[Micron]

Answer given and accepted yesterday at

iif statement help change to yes or no or a check box.

Hi All - new here so be kind. I am trying to set the cell that if it doesn't have an OrderNum then the field is says NO. However when I run it - it shows NO on every line. Room: IIf(IsNull()=Null,Null,"NO") Background I have two tables. One with all Orders and one with Orders that contain a...

www.accessforums.net

 

[Joe4]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: iif statement help change to yes or no or a check box.
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[MattC66]

Not sure how to mark the problem as solved. Yes the above responses solved it.

 

[MattC66]

Not sure how to mark the problem as solved. Yes the above responses solved it.

Right after I posted this - saw the how.. Sorry now I am not sure how to delete my post.