Solved

Comparing two fields when one is null

Posted on 2014-01-17
2
482 Views
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!
SAMPLETEST.accdb
0
Comment
Question by:daisypetals313
2 Comments
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
ID: 39789349
Try this modification
SAMPLETEST.accdb
0
 

Author Closing Comment

by:daisypetals313
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.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

832 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