title: SQL Query in Access with YesNo field Returns No Results
body: <p>I am learning to use SQL in Access 2013 and things are going well, but I'm having some trouble with one of the objectives of the assignment. First of all, here is the table information that I need to consider:</p>
  
  <pre><code>Field Name          Data Type
  StudentID           Short Text
  FirstName           ""
  MiddleInitial       ""
  LastName            ""
  DateofBirth         Date/Time
  GradePointAverage   Number
  Major               Short Text
  CreditsEarned       Number
  Probation           Yes/No
  USCitizen           Yes/No
  Class               Short Text
  </code></pre>
  
  <p>What I need to do is determine the students on Probation who are not US Citizens. Following is my SQL Query Code:</p>
  
  <pre><code>SELECT   StudentID, LastName, FirstName, Major, Probation, USCitizen 
  FROM Student
  WHERE    Probation = 1
  AND      USCitizen = 0;
  </code></pre>
  
  <p>There is one record on the Student table that should show up as a result when I run this query, but the query is blank instead, showing the column names but with no rows of data. This is just one aspect of a larger assignment and while I'm not having any difficulty with the other objectives, this one is stumping me. Why is it not returning the one row result? What am I doing wrong here?</p>