Forum Discussion
Eric_1226
Jul 19, 2021Copper Contributor
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...
isladogs
Jul 19, 2021MVP
It gives the correct results for me.
BTW you can simplify the expression to Mid([N]*0.65-Int([N]*0.65),4,1)
BTW you can simplify the expression to Mid([N]*0.65-Int([N]*0.65),4,1)