how to find a record between two values : <p>I have the following <a href="https://i.stack.imgur.com/pSWaz.jpg" rel="nofollow noreferrer">table</a> where there are two relevant fields for searching, this is 'from' and 'to' and represents the range of employees and then the field 'InitialQMSDays' represents the value that I want to return.</p>

<p>So if I have a search value of say 6, it would look at that value and find it between the 6 - 10 row, and return 2.  </p>

<p>any ideas?</p>
