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...
Thanks. That's great stuff. I am guessing that's a MS version thing? Mine's 2016.
No. It is a Windows setting.
