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
      Database;DBQ=C:\daily\msn_bs.mdb]
      ;
      SQL SELECT SO2010,

          CashAll2011

      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.

       

       

      Thanks

       

      John