Forum Discussion

Eric_1226's avatar
Eric_1226
Copper Contributor
Jul 19, 2021

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...
access
isladogs's avatar
isladogs
MVP
@Gustav.
Thanks.That's even better.
I tried to 'Like' your reply but can't yet work out how to do so on this site

Eric
I don't believe its the cause of your issue but NUMBER is a reserved word in Access and shouldn't be used for a field name
isladogs's avatar
isladogs
MVP
Jul 21, 2021
Success. Post successfully liked!
  • Eric_1226's avatar
    Eric_1226
    Copper Contributor
    Jul 22, 2021

    isladogs Thank you guys. Those were valuable recommendations. Though NUMBER was just an example. All of your simplifications would definitely get the job done but I would still very much like to figure out why my device keeps returning different result from other devices and why the LEFT function don't count decimal points as other devices do.:cryingwithlaughter: I have like 20 different Access and it looks like I will just have to change code for em all.

Resources