Comparing two fields when one is null

Posted on 2014-01-17
Medium Priority
Last Modified: 2014-01-17
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!
Question by:daisypetals313
LVL 41

Accepted Solution

als315 earned 2000 total points
ID: 39789349
Try this modification

Author Closing Comment

ID: 39789387
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.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

619 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question