title: MS Access query: records with empty fields?
body: <p>I got a little problem with a query in MS Access 2010.</p>
  
  <p>I have a huge table (<code>tblItemRunData</code>) mainly consisting of foreign keys. Now I want to make query out of it but in combination with the related tables to get the information behind each foreign key.</p>
  
  <p>The problem I have is, that some fields in the <code>tblItemRunData</code> itself or in the related tables may be empty. If they are empty or more like <code>Null</code>, than the query won't show the records to me.
  I'm aware of why this is happening: <a href="http://office.microsoft.com/en-us/access-help/about-working-with-blank-fields-in-queries-mdb-HP005188534.aspx" rel="nofollow noreferrer">http://office.microsoft.com/en-us/access-help/about-working-with-blank-fields-in-queries-mdb-HP005188534.aspx</a></p>
  
  <p>But I can't find a way to manipulate the query to show me all the records where fields may be empty or not.
  I tried to set the criteria of every field I want to use to:
  <code>Is Null OR Is Not Null</code> which did not work for me.</p>
  
  <p>I hope my explaining is good enough for you to understand my problem and I really hope someone got the answer for me.</p>
  
  <p>I would really appreciate it. Thanks in advance.</p>
  
  <hr>
  
  <p>Here are some screenshots to make it a little easier to understand (i hope it does make it easier)</p>
  
  <p>Huge table with many FKs and related tables<img src="https://i.stack.imgur.com/KyVPc.png" alt=""></p>
  
  <p>What the query is giving back. I also tried it without the <code>Is Null</code> and <code>Is Not Null</code><img src="https://i.stack.imgur.com/R9HWA.png" alt="enter image description here"></p>
  
  <p>Records that are actually in the table. As you can see, <code>prioID_Ref</code> is not set for records no. 5 and some other fields are not set for record no. 4. Thats why I dont get them in the query<img src="https://i.stack.imgur.com/TVmGt.png" alt="enter image description here"></p>