Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Comparing two fields when one is null

Posted on 2014-01-17
2
Medium Priority
?
497 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 40

Accepted Solution

by:
als315 earned 2000 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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

580 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