Re: Convert string to Number

From: ricky (anonymous_at_discussions.microsoft.com)
Date: 03/12/04 

Date: Fri, 12 Mar 2004 00:31:06 -0800

thanks parkar,

before, my table looks like
DateInsert StrFormula
2004/01/01 , 150000*0.9*21/31
2004/02/01 , 150000*0.8*21/28
2004/03/01 , 150000*0.87*21/31

After,
DateInsert result
2004/01/01 , 91451.61
2004/02/01 , 90000
2004/03/01 , 88403.22

first of all thanks of ur suggestion. i have a field(StrFormula) in table A and this field contains string("150000*0.9*21/31"),i want to calculate these string at specific time and return results.