Hi Penny -
Unless I'm not understanding your question, this is exactly what is covered in Lesson 1 of  this Beginner 6 series.  The opposite of IS NULL is IS NOT NULL.

Remember that a query is just a way to display your data.  All of the data is still there.  You are just limiting what you are looking at.

.

Hi Scott,
I dont think I am explaining it right
In my new query I want to use the CustomerT & CustomerWithFullAddressQ and somehow say can you display all the records in the CustomerT which were not displayed in the CustomerWithFullAddressQ

Hope this is clearer Penny

You can just make a new query, CustomerWithoutFullAddressQ and instead of doing is not null all the way across on one line. You would say Is Null on one line, then go down a line (this means OR), and put is null on the next field. Essentially giving you a list of things that had a null and didn't showup.

Penny -
I think we are saying the same thing.  The two different queries are the way to go.  One has addresses that are missing info the other has all the addresses that are complete. Essentially you are telling Access "take all the data and show me only the records with this criteria."  

Remember - You as the developer of the data base get to work with the queries.  Your USER of the database shouldn't see these query data this way.  Developer You would create a Form to present the data to the user in the way that you want them to be able to interact with the data. There are several ways to make that happen. You could use check boxes, or buttons, or a combo box for instance.

So, for instance, on that form you could put a combo box that defaults to All records, or you could choose good, or bad addresses.
Each of those choices would then utilize the queries that you just built depending on the choice you make.

Make sense?