Access 奇怪的無條件捨去 Int 函數
在 Access 的 VBA 中
vInt = 77.32 * 0.5 ==> 38.66
vInt = 77.32 * 0.5 * 100 ==> 3866
vInt = Int(77.32 * 0.5 * 100) ==> 3865 竟然少1
vInt = Int(77.32 * 0.5 * 100) / 100 ==> 38.65 取小數第二位無條件捨去的結果,竟然少0.01
vInt = 77.32 * 0.5 * 100 ==> 3866
vInt = Int(vInt) / 100 ==> 38.66 將數值成 100 放在變數,再將變數取整數,再除於100,則結果就沒問題
不知這是什麼問題, 看來只好多用一條式子,再轉換,而不能一式到底,這是不是 呷緊弄破碗
迴響
Access 奇怪的無條件捨去 Int 函數 | 豬窩
Hey there just wanted to give you a brief heads up and let you know
a few of the images aren't loading correctly. I'm not sure why but I think its a linking issue.
I've tried it in two different internet browsers and both
show the same outcome.
Access 奇怪的無條件捨去 Int 函數 | 豬窩
I'm curious to find out what blog system you're
utilizing? I'm having some small security issues with
my latest blog and I'd like to find something
more secure. Do you have any suggestions?
Access 奇怪的無條件捨去 Int 函數 | 豬窩
Wow, that's what I was searching for, what a information! present
here at this website, thanks admin of this website.
Access 奇怪的無條件捨去 Int 函數 | 豬窩
Wow that was odd. I just wrote an incredibly long comment but after I
clicked submit my comment didn't show up.
Grrrr... well I'm not writing all that over again. Anyway, just wanted
to say fantastic blog!
Access 奇怪的無條件捨去 Int 函數 | 豬窩
Hello, yup this piece of writing is in fact nice and I have learned lot of things from it regarding blogging.
thanks.