Forum Discussion
Left Function in Access Doesn't Count Decimal Point As a Character
So I am tryting to do Select Right(Left([NUMBER]*0.65-Int([NUMBER]*0.65),4),1) to get the 4th character ( so the 2nd decimal place, e.g. to return {3} from {1.234}) of this resulting number in a qu...
Eric_1226 : I can't replicate your issue. But, that said, always handle numbers as numbers, not text.
Thus:
Digit2 = Int([NUMBER]*0.65*100) Mod 10
Thanks. That's great stuff. I am guessing that's a MS version thing? Mine's 2016.
- No. It is a Windows setting.