title: SQL adding new column that divides figures in other columns
body: <p>I have been trying to operate this code for a while but to no avail - Any help is appreciated:</p>
  
  <p>I have a listbox that has two columns with numbers in (figures are pulled from queries. In the listbox I want to add a third column that divides column two by column one.</p>
  
  <p>My code:</p>
  
  <pre><code>    SELECT 
       Q_Manager_CHS_Total.tbl_CEAR_Name.CEAR_Team
       T1.Q_Manager_Backlog_Total.Backlogs
       Q_Manager_CHS_Total.CHS_Total
  
        (T1.Q_Manager_Backlog_Total.Backlogs/Q_Manager_CHS_Total.CHS_Total) AS AverageNumber
  FROM 
       Q_Manager_CHS_Total
  INNER JOIN (SELECT Q_Manager_Backlog_Total.Backlogs, tbl_CEAR_Name.CEAR_Team 
  INNER JOIN tbl_CEAR_Name ON Q_Manager_Backlog_Total.CEAR_Team = tbl_CEAR_Name.CEAR_Team) AS T1 
  ON Q_Manager_CHS_Total.CEAR_Team = T1.CEAR_Team
  ORDER BY T1.Q_Manager_Backlog_Total.Backlogs DESC;
  </code></pre>
  
  <p>Any help trying to get this working is appreciated. </p>
  
  <p>UPDATE: The SQL below works and shows the two columns, its adding the third column I cant seem to do.</p>
  
  <pre><code>    SELECT Q_Manager_CHS_Total.tbl_CEAR_Name.CEAR_Team, T1.Q_Manager_Backlog_Total.Backlogs, Q_Manager_CHS_Total.CHS_Total
  FROM Q_Manager_CHS_Total INNER JOIN (SELECT Q_Manager_Backlog_Total.Backlogs, tbl_CEAR_Name.CEAR_Team FROM Q_Manager_Backlog_Total INNER JOIN tbl_CEAR_Name ON Q_Manager_Backlog_Total.CEAR_Team = tbl_CEAR_Name.CEAR_Team) AS T1 ON Q_Manager_CHS_Total.CEAR_Team = T1.CEAR_Team
  ORDER BY T1.Q_Manager_Backlog_Total.Backlogs DESC;
  </code></pre>