title: Data type for currency values in Access
body: <p>I am working on database homework for school. I'm not able to think right now with lack of sleep I've been getting, but I know this is a simple question. </p>
  
  <p>I have this create table statement and in it, I am supposed to have 3 columns <code>cusNo</code>, <code>add</code>, and <code>balance</code>, which I can do fine. But my problem lies in the last column. the last column is for balance and is supposed to have a numerical value of 5 digits. to do so, when I create the column for balance, would I just have to create it as a double? </p>
  
  <p>Something like this:</p>
  
  <pre><code>CREATE TABLE tablename
  (
    cusNo char(3),
    add varchar(20),
    balance double
  )
  </code></pre>