title: MS Access 2003: Check if data is within range from another table
body: <p>I have two tables, Table A with the hours, and Table B to have Grade, and minimum Hour required</p>
  
  <p>What I'm trying to do is to assign TableB.Grade to TableA depending on how much hours each record has. </p>
  
  <p>Example:</p>
  
  <p>TableA</p>
  
  <pre><code>Name        Hours       
  Person A     205
  Person B     105
  Person C     400
  </code></pre>
  
  <p>Table B</p>
  
  <pre><code>Grade       HoursRequired
  1              0
  2              100
  3              200
  4              300
  </code></pre>
  
  <p>My expected report</p>
  
  <pre><code>Name      Hours     Grade
  Person A    105     2
  Person B    205     3
  Person C    400     4
  </code></pre>
  
  <p>Any advise on the SQL coding or restructuring of table would be appreciated.</p>