title: Select field from recordset that is between dates
body: <p>Here is an example as it is pretty difficult to explain:</p>
  
  <p>Table one:</p>
  
  <pre><code>| Date        | Place ID |
  ==========================
  | 01-Feb-2013 | 1        |
  | 21-Jun-2015 | 2        |
  </code></pre>
  
  <p>Table two:</p>
  
  <pre><code>| Place ID | Date Ranked | Score |
  ==================================
  | 1        | 01-Jan-2012 | 2     |
  | 1        | 01-Jan-2014 | 1     |
  | 1        | 01-Jan-2010 | 3     |
  | 2        | 01-Jan-2016 | 1     |
  </code></pre>
  
  <p>What I want to happen is with SQL (MS) is when the first record of table one is returned I want whatever the score at that time to be returned from the second table. So in this example the score should be 2 as it is after 01-Jan-2012 but before 01-Jan-2014. And when the second record from table 1 is returned it should return NULL or blank from table 2 as no score existed for that time chosen.</p>
  
  <p>Hope that makes sense!!</p>