Here is a screenshot of the Query and the Run of the Query

What do you want achieve?

It looks like your Query is working correctly.
You are telling Access that you don't want to see records with no Address AND no City AND no State AND no ZIP.
That is what your result set is showing.

that is what Rick did in the lesson. The way I see it is it should be an OR not an ANS Query. but I tried it that way with the same results

The Is Not Null is not working for the State field as you see in this example. Is it an issue with Access?

Zero Length

It is confusing, but the Video Alex is referring to describes what you're seeing.

When a field is first created, there is no value in the field.

This is different from adding text and then removing text.  If there was a text value in the field, then you remove the text, it's stored in the database as text variable type with no text in it, which is not the same as NULL.

If you keep watching, Rick will cover this in more detail.

-Raymond

FYI- I figured out the issue with this query. This is the second time I have gone through these lessons and I took a shortcut during the construction of the database, I imported the customer list rather than typing each on in separately. When I reentered the data manually the query works fine.
So! apparently if you import the database info you have issues with queries.