title: approximate Vlookup function in MS Access?
body: <p>In Access I have a table, where I enter the times I began and finished work for each day. Logically, these two numbers allow you to calculate how long you worked.
  In another Table I have currently four records, defining how long the lunch break has to be on a specific day, based on how long I worked that day, something like this</p>
  <p>Minimum work time; Minimum break</p>
  <p>0:00; 0:00</p>
  <p>5:31; 0:15</p>
  <p>7:01; 0:30</p>
  <p>9:01; 1:00</p>
  <p>In Excel I can use the Vlookup, set to work with approximate times. For example, if one day the duration was 7:42, the Vlookup would return &quot;0:30&quot;, going to the closest lower value, 7:01, and returning 0:30.
  Is there a function in the formula editor in the query window of Access to solve this problem or does Access just lack this possibility? I'm just very curious about that.</p>