4 Replies Latest reply: Jun 22, 2012 2:46 AM by shadowstock RSS

    New Calculated Field

      I'm trying to create a new field in the script so I can add
      this new field in sheets when needed.



      ODBC CONNECT32 TO [MS Access
      SQL SELECT SO2010,


      FROM `msn_BS`;



      How would I create a new field called test that calculates in theory cash per share. So the new  field called test would take  the
      field loaded CashAll2011 and divided it by SO2010 to create a value in the new field called test.


      the new field test = CashAll2011/ SO2010



      how can I do this?


      Sorry I'm new and trying to avoid doing all the work in Excel.