title: Remove Decimal Places with Access SQL Query
body: <p>I'm working with MS Access to do some math. I'm taking a Cost and Dividing it by a decimal value to get a Price. I'm using a link table and a access sql query.</p>
  
  <p>SQL Ex</p>
  
  <pre><code>Select (cost/markup) As Price From T_Cost;
  </code></pre>
  
  <p>Calulcation Ex. 
  1234 / .55 = 2243.6363
  1000 / .50 = 2000</p>
  
  <p>I'm trying to figure out a way to remove the decimal places that will work when there are decimals and when there are not.</p>
  
  <p>I was thinking of doing something like this in my Access SQL:</p>
  
  <pre><code>Mid("2243,6363", 0, Instr("2243,6363","."))
  </code></pre>
  
  <p>But this won't work if there is not a decimal place. </p>