title: How to Change Column Field Format in Microsoft Access with SQL
body: <p>I need to be able to write a script to create a table in Microsoft Access, and I am running into a problem.  I need a long integer field (longer than <code>LONG</code>), so I have to use <code>DECIMAL</code>.  The problem I am running into is it is defaulting the <strong>Format</strong> to scientific notation.  I need it to stay as a normal integer value.</p>
  
  <p>Here is my script:</p>
  
  <pre><code>CREATE TABLE MY_TABLE
  (
     MY_GUID GUID CONSTRAINT MY_CONSTRAINT PRIMARY KEY,
     MY_NAME VARCHAR,
     CREATOR VARCHAR,
     MILLI_CREATED DECIMAL (13, 0)
  );
  </code></pre>
  
  <p>The <code>MILLI_CREATED</code> field defaults to <em>General Number</em> <strong>Format</strong>, which then displays the value in scientific notation, like this:  <code>1.444255960009E+12</code></p>
  
  <p>How can I set the <strong>Format</strong> of the table during <code>CREATE</code> or with an <code>ALTER</code> or even at <code>INSERT</code> if that is what I have to do?</p>