Comparing two fields when one is null

I have a set of queries that compare the values of columns in two different tables and returns values for those that are different.  

In the attached file, it works fine for my City Query, however, with my Company Query you can see that when one of the tables has a null value it doesn't work.  

Any suggestions as to how to address this?  Thanks!
SAMPLETEST.accdb
daisypetals313Asked:
Who is Participating?
 
als315Connect With a Mentor Commented:
Try this modification
SAMPLETEST.accdb
0
 
daisypetals313Author Commented:
Thanks, this is it!

I also added a 3rd line to the query reversing the null/not null so that the Compare would work both ways.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.