Making an Integer a Single

[JennJenn]

Making an Integer a Single

I have a calculated field that does the following:
After the calculations are performed, for example fld1 is 2.5 plus fld2 is 2.4 plus fld3 is 2.3(2.5 + 2.4 + 2.3), the result(fld3) gives 7 instead of 7.2. How can I make the field give 7.2(as a double or single) while keeping the table properties set as text?

Thanks.

 

[DJN]

Not quite sure where you are performing your addition, but if you place val before each field being calculated, it will treat the text as numeric. e.g. fld3= val(fld1)+val(fld2) This will keep the number of decimal places entered.

David

 

[JennJenn]

Thanks so much David! Problem Solved!!