title: How to use MS Access SQL subquery in WHERE clause to replace long OR expressions
body: <p>I'm trying to extract time log records for interesting projects, like so:</p>
  
  <pre><code>SELECT project, hours, date
  FROM timelog
  WHERE (project="one" or project="two" ... 20 more OR clauses)
  </code></pre>
  
  <p>But since I have a table containing the interesting projects, I want to say</p>
  
  <pre><code>SELECT project, hours, date
  FROM timelog
  WHERE project in (select project from InterestingProjects)
  </code></pre>
  
  <p>Unfortunately for me, I have had nothing but abject failure trying to do this on MS Access. The subquery seems to return only a few interesting projects, almost like only the first one starting with c, the first one starting with s, etc.</p>
  
  <p>Am I trying to do the impossible? (Then I want to group and sum the rows by interesting project, but that's a second step, I think.) Thank you.</p>