Forum Discussion

Carol_95's avatar
Carol_95
Copper Contributor
Sep 19, 2022

MS Access MID-Function automatic change "," into "."

I have some issue with my queries in MS Access version 

Microsoft Access for Microsoft 365 MSO (16.0.14326.21052) 64-bit

 

When create a query using Mid-function, Mid([RCV_RECEIVD_REC],3,3) MS Access changes this to Mid([RCV_RECEIVD_REC],3.3)  with a point "." 

 

Can someone tell me what to do?

Thanks

 

access
  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Sep 19, 2022
    What is your computer decimal separator. Is it comma (,) or dot (.)? Based on regional settings you may need to use semicolon (;) instead of comma (,). Can you please share a small sample file with the issue?

Resources