title: Extract Whole Number From Decimal In Access Expression
body: <p>I'm having trouble extracting the whole number from a number field in the expression builder in Access.</p>
  
  <p>Here's what I thought would work:</p>
  
  <pre><code>Left([NumField],InStr(1,[NumField],".")-1)
  </code></pre>
  
  <p>This does not work. Upon running my query, I get a message box popping up stating "Invalid Call Procedure"</p>
  
  <p>Field before the expression = 1.4</p>
  
  <p>Field after the expression = 1</p>
  
  <p>Thus taking the whole number and extracting that. Of cource the whole number could be 3, 30 or 300. The length will be different at all times, so you can't use trim left for a length of 1.</p>
  
  <p>Suggestions?</p>