有關access中數值轉換-------------在線等

akxiang 发布于 2007-08-17 08:51， 612 次点击

請問各位：
我要將百分數值的字符串型，轉換成數值型的百分數。應該如何轉換呢？(題目是這樣子的，不用想直接在數據庫裡面就設成百分數的數值型。)
請幫忙!!!!

7 回复

akxiang2007-08-17 09:03

我搞錯了。不好意思!!!!

問題應該是：
怎麼將小數值的數字轉換成百分數。如將0.953轉換成95.3% ????

ayue2222007-08-17 09:08

FormatPercent (0.953)

QQQQQQQQQQQQ2007-08-17 09:15

aa="100%"
aa=replace(aa,"%","")/100

QQQQQQQQQQQQ2007-08-17 09:17

formatpercent(0.953,1)

QQQQQQQQQQQQ2007-08-17 09:24

根据小数长短收缩
<%
aa="0.95344"
bb=len(mid(aa,instr(aa,".")+1))-2
aa=formatpercent(aa,bb)
response.write aa
%>

QQQQQQQQQQQQ2007-08-17 09:28

<%
aa="0.95344"
aa=(aa*100)&"%"
response.write aa
%>

akxiang2007-08-17 09:36

謝啦!!!