If you were to put "Is Null" on the same line in the "or" right across in each field, does it affect anything? You put "Is Null" in each of a different place under the "OR" section. It's like a step ladder. Are you suggesting that is a good way of writing a code/program? Index Time: 12:40-12:50.
Reply from Richard Rost:
If you go straight across one row, you're making an AND condition. So FirstName Is Null AND LastName Is Null AND CompanyName Is Null.
If you go DOWN one "OR" row each column, then it becomes an OR condition. So you get FirstName Is Null OR LastName Is Null OR CompanyName Is Null.
It all depends on your needs.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 6.