title: dividing two fields from two different tables
body: <p>In an MS Access 2010 database, I have two tables which each have a common key.  I want to divide the value of a field in one of the tables by the value of a different field in another table.  How do I accomplish this in MS Access SQL code?</p>
  
  <p>I want to do this in SQL.  There is no graphical user interface.  </p>
  
  <p>Here is what I have so far:  </p>
  
  <pre><code>SELECT result AS (tblone.DAYS / tbltwo.DIS) 
  FROM tblone INNER JOIN tbltwo
  ON tblone.NO = tbltwo.NO;  
  </code></pre>
  
  <p>NOTE: the <code>DAYS</code> and <code>DIS</code> fields are both of data type <code>Double</code>.  <code>NO</code> is a <code>Long Integer</code> in both tables.  </p>